Use a helper column and put this formula in it's top row, assuming no
headers, and copy down..........
=IF(OR(B10,C10,D10),1,"")
Then Autofilter on this column for "1"
Vaya con Dios,
Chuck, CABGx3
"Fahad Ashfaque" wrote in message
...
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
|