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...
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).
