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,(Maste...
Are you sure #N/A is part of the spill returned by FILTER(), are they with source data?