Find blank with Advanced Filter

C

CJ

Hi Groupies

I have an XL 2007 database that has some blank cells in the postal code
field. I realize that I can filter these blanks very easily using Autofilter,
but how can I find them using Advanced Filter? What do I need to put in the
criteria range?
 
D

Debra Dalgleish

In the rcriteria area, enter the column heading in the first row.
In the cell below, enter: ="="
For example, to find records with no price entered:

Price
="="
 

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


Top