advanced filter for blanks

B

BorisS

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

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

advanced filter looking for blank cells 1
Find blank with Advanced Filter 1
Advanced Filter for blank fields in multiple rows 3
Advanced filter 7
Filter (blanks) with two or more unique values not working 1
SUMIF non-blank cells? 5
Blanks and Advanced Filters 7
Cell reference formula problem 5

Top