Feb 16 2022 05:36 AM
Hi experts,
Quick one for you....
I use this formula to hand pick some data from another table and it works fine. However if there is a blank line in the original table, I get blanks displayed also in my filtered table.
Any ideas how to adjust the formula to ignore blank entries?
Many thanks
=IFERROR(INDEX('Absence Log'!$E:$E,SMALL(IF('Absence Log'!$K$13:$K$499="",ROW('Absence Log'!$K$13:$K$499),FALSE),ROW()-10)),"")