advanced filter for blanks
 

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

advanced filter for blanks
 

In the criteria range, leave the heading cell blank
IN the cell below, enter the formula:
=AND(A2<"",B2<"")

When running the advanced filter, select the blank heading cell and the
cell with the formula as the criteria range.

BorisS wrote:
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.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com