Excel: How to exclude Errors from Filter function

user_1376778 0
Viewed 333

Using the array formula below in Excel I get 5 results and 5 empty rows as intended

FILTER(MyDatatable; MyDatatable[column2] = A1; "Nothing found")

However the 5 empty rows return #N/A and I can't get rid of them using IFNA or IFERROR

any suggestions?

excel-formula excel
1 Answers

=FILTER(MyDatatable; MyDatatable[column2]=INDIRECT("'"&$A$1&"'!I92");"Nothing found") is most likely what you want. As explained in my comment.

user_126342300
Related