Forum Discussion
Removing N/A from FILTER Function
I have the following formula working pulling data from a Master database worksheet to another worksheet using to criteria a dropdown of options of DataPoint2 in B1:
=FILTER(Master!A2:H1233,(Master!E2:E1233="DataPoint1")*(Master!D2:D1233=B1),"No data")
When I save the file, I get #N/A's under the rows that are successfully pulling from the master sheet. I have tried the following that have not worked. I am certain I have been looking at this for far too long and would really appreciate your help:
=IFNA(FILTER(Master!A2:H1233,(Master!E2:E1233="DataPoint1")*(Master!D2:D1233=B1)),””)
=IF(ISERROR(FILTER(Master!A2:H1233, Master!E2:E1233="DataPoint1")*(Master!D2:D1233=B1)),””, (FILTER(Master!A2:H1233, Master!E2:E1233="DataPoint1")*(Master!D2:D1233=B1)))
1 Reply
Are you sure #N/A is part of the spill returned by FILTER(), are they with source data?
