need the specific values from a table

JAlandhar 201718

Member
Hello Everyone,

This is Anshum this side, and I need help as I need specific values from a table, which is updated with hourly basis with new entries, I just need specific values in return as "the amount in the table>0" . Please help me with the formula that i can update my sheet for better result.

Attachments

• 9.9 KB Views: 8

salim hasan

New Member
Try this file
Array Formula in G10 ====>(control+Shift+Enter)
Code:
``=IF(ROWS(G\$10:G10)>COUNTIF(\$D\$8:\$D\$100,">0"),"",INDEX(A\$8:A\$100,SMALL(IF(\$D\$8:\$D\$100<>"",IF(\$D\$8:\$D\$100>0,ROW(\$A\$8:\$A\$100)-ROW(\$A\$8)+1)),ROWS(G\$10:G10))))``

vletm

Excel Ninja
JAlandhar 201718
1) Create Criteria to G4:G5
2) Select List Range
4) Modify Parameters as below
5) Press [OK]

JAlandhar 201718

Member
Try this file
Array Formula in G10 ====>(control+Shift+Enter)
Code:
``=IF(ROWS(G\$10:G10)>COUNTIF(\$D\$8:\$D\$100,">0"),"",INDEX(A\$8:A\$100,SMALL(IF(\$D\$8:\$D\$100<>"",IF(\$D\$8:\$D\$100>0,ROW(\$A\$8:\$A\$100)-ROW(\$A\$8)+1)),ROWS(G\$10:G10))))``
should I follow the same formula for all the columns & rows, to get the proper result

JAlandhar 201718

Member
JAlandhar 201718
1) Create Criteria to G4:G5
2) Select List Range
4) Modify Parameters as below
5) Press [OK]
View attachment 55672