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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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