Forum Discussion
Solved
How to use the ISBLANK function as an Advanced Filter criteria
I have a data set that needs to be filtered for all rows that are non-blank in EITHER of two columns. Since the standard filter feature performs an AND on the two criteria, I need to use the Advanced Filter feature to set up an OR on the two criteria. I tried using ="=NOT(ISBLANK())" as the criteria in my Advanced Filter criteria range, but get zero results.
2 Replies
HansVogelaar thanks for that syntax tip. Much simpler than the workaround I used (created a new column where I stuffed the results of a boolean formula, then filtered on that column).
