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

[Ron Coderre]

Try this criteria:

<>?*

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

Does that help?

Regards,
Ron

[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


"dougfalcon" <[email protected]> wrote
in message news:[email protected]...
>
> 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???????
>
>
> --
> dougfalcon
> ------------------------------------------------------------------------
> dougfalcon's Profile:
> http://www.excelforum.com/member.php...o&userid=34432
> View this thread: http://www.excelforum.com/showthread...hreadid=541975
>