in '07 (in case it matters), I am trying to use advanced filter for non-blank
cells. Specifically, I want an OR for two columns, either of which can be
non-blank. So basically
IF(AND(not(isblank(column(a))),not(isblank(column( b))). Something like that.
In other words, I want to see all non-blank cells of column A and B (and
obviously the other row data for that subset.

I have tried using, on subsequent rows (i.e., staggered criteria range A2
and B3) "not(isblank())", but not surprisingly that doesn't work. Have also
tried entering
="<"""
but that doesn't seem to translate to (<"") in the criteria either.

How do I indicate I'm looking for non-blanks?

thx.
--
Boris