Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Joining Multiple filters with OR rather than AND
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) |