Advanced criteria

[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???????

 

[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

 

[Ron Coderre]

Try this criteria:

<>?*

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

Does that help?

Regards,
Ron

 

[Ron Coderre]

Try this criteria:

<>?*

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

Does that help?

Regards,
Ron