Forum Discussion
Solved
How to get list ignoring blank cells
I am having data in table with 2 column in one sheet. Column 1 has data in text form. Column 2 has data in number form. I need result in another sheet with following condition. - Ignore blank ...
=IFERROR(INDEX($A$2:$A$25,SMALL(IF($B$2:$B$25<>"",ROW($A$2:$A$25)-1),ROW(A1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
