Can anyone help with this spreadsheet? Thanks.
Can anyone help with this spreadsheet? Thanks.
To do what ???? Please explain what you want.
Need a formula to skip the blank cells like this:
COLUMN 1
-A
-(BLANK CELL)
-(BLANK CELL)
-D
-E
-F
-(BLANK CELL)
-H
-(BLANK CELL)
Result from the formula
-A
-E
-F
-H
Thanks
In A33
=IFERROR(INDEX($A$2:$A$29,SMALL(IF(B$2:B$29>0,ROW($A$2:$A$29)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
Enter with Ctrl+Shift+Enter
Copy across and down
Thanks, repped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks