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