Use a formula, assume you use G1:G2 as criteria range, leave G1 blank and in
G2 put
=ISBLANK(A4)
where A4 is the first cell with data that you want to filter
note that ISBLANK will return false for blank from formula like "", so if
that's the case us
=A4=""
--
Regards,
Peo Sjoblom
"Heinzpickle" wrote in message
...
I am using advanced filter and want to filter for a blank cell. I thought
that, to do this, you would use a "" but this does not appear to work. Is
there another way to filter for blank cells, or am I wrong?
--
HeinzPickle
|