How to use the ISBLANK function as an Advanced Filter criteria

[Bob_Beims_SBG]

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 · Accepted solution]

@Bob_Beims_SBG 

You can use <> in the criteria range:

[#3]

@Hans Vogelaar 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).