Advanced criteria

D

dougfalcon

When using data filter advanced. How does one filter, when the criteria
wants data from one column only when another column is blank.
I have tried ="=""" for the blank column, but it does'nt work???????
 
P

Peo Sjoblom

A couple of ways, if you use a header in H1 then in H2 put

=

if you use a formula, then leave H1 blank and refer to the first data cell
in H2

=B5=""

Assuming B5 is the first data cell in the column with blanks and H1 and H2
the cells referred to in the criteria

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
R

Ron Coderre

Try this criteria:

<>?*

That should display true blanks and cells containing: =""

Does that help?

Regards,
Ron
 
R

Ron Coderre

Try this criteria:

<>?*

That should display true blanks and cells containing: =""

Does that help?

Regards,
Ron
 
Top