Advanced Filter for blank fields in multiple rows

  • Thread starter Thread starter ronlaforce
  • Start date Start date
R

ronlaforce

I need to filter for blank cells. It will usually be a single criteria in
more than one column. It will be 'and'.

I know that I have to place all criteria in the same row for 'and'.
However, I can't seem to filter out the blank cells. I keep getting nothing
or everything. What is the correct method for filtering for blank cells?

Thx,

Ron
 
Hi,

Show us a sample of your data and the desired results. Are you trying to
filter where two columns both contain blanks at the same time or where one or
the other contains blanks, it's not clear.
 
In the criteria range, add the same heading as the column you want to
filter in the table.
In the cell below, type: ="="
Include that heading and formula in your criteria range when you run the
Advanced Filter

There are other criteria examples here:

http://www.contextures.com/xladvfilter02.html
 
Shane & Debra,

Thank you for your help. It worked. Just what was needed.
 
You must log in or register to reply here.

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 for blanks 1
Find blank with Advanced Filter 1
Force a filter beyond blank rows 1
Filter (blanks) with two or more unique values not working 1
questions on advanced filter 4
Advanced Filter for Empty Cells 5
advanced filter looking for blank cells 1
Sorting or filtering for rows 1

Back
Top