Joining Multiple filters with OR rather than AND

[Guest]

Hello,
I am applying filter to a very simple worksheet like the following

Date Height Width Length
1/1/2005 45 89
2/2/2005 40
2/3/2005 65
2/4/2005
2/5/2005
2/6/2006 780 89
3/5/2005
2/3/2004
2/3/3006
2/3/2003 87

I need to apply filter such that if there is no value in Height and Width
and Length; it should hide the row. If one of the three rows has data
(nonblank) it should not.

Problem is when i apply "nonblank" filter on all three column, it hides all.

Anyhelp regarding this would be appreciated.


Thanks,
Fahad

 

[Bob Phillips]

Hi Fahad,

I would add a helper column with a formula in, like so

=COUNT(B22)

and filter on the helper column for a value of 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[CLR]

Use a helper column and put this formula in it's top row, assuming no
headers, and copy down..........

=IF(OR(B1>0,C1>0,D1>0),1,"")

Then Autofilter on this column for "1"

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks a lot both of you guys, It really did help.