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

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

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

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

"CLR" wrote:

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