• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need the specific values from a table

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

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))))
 
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
 
Top