Hi Fahad,
I would add a helper column with a formula in, like so
=COUNT(B2:D2)
and filter on the helper column for a value of 0.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|