Forum Discussion
Solved
Formula Required to Extract data from Column A based on Non -zero values in Column B
Hey guys. I need to know the formula to Extract data from Column A based on Non -zero values in Column B. I have successfully done this task in past to extract the data from same column using the c...
Please try this...
In E2
=IF(ROWS(D$2:D2)>COUNTIFS($A$2:$A$10003,"<>",$B$2:$B$10003,">0"),"",INDEX($A$2:$A$10003,AGGREGATE(15,6,(ROW($A$2:$A$10003)-ROW($A$2)+1)/(($A$2:$A$10003<>"")*($B$2:$B$10003>0)),ROWS(D$2:D2))))and copy it down.
Please try this...
In E2
=IF(ROWS(D$2:D2)>COUNTIFS($A$2:$A$10003,"<>",$B$2:$B$10003,">0"),"",INDEX($A$2:$A$10003,AGGREGATE(15,6,(ROW($A$2:$A$10003)-ROW($A$2)+1)/(($A$2:$A$10003<>"")*($B$2:$B$10003>0)),ROWS(D$2:D2))))and copy it down.
Is there anyway to display both columns (A,B) of the fields ?
Please advise how to?