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

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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>

Try this criteria:

<>?*

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=541975

Try this criteria:

<>?*

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=541975