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 he

http://www.contextures.com/xladvfilter02.html

ronlaforce wrote:
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


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