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
="="
 
Top