Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
How can I filter an entire sheet for all instances where H2 (and on down) =
NO and I2 (and on down) is non blank? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Hi
Use AutoFiler. Select column H and I then goto Data Filter AuroFilter Ok At the top to the columns is a drop down field, click on the one in column H first and select NO, then click on the drop down field in column I and select NonBlanks. Regards, Per "Jeremy" <jeremiah.a.reynolds @ gmail.com skrev i meddelelsen ... How can I filter an entire sheet for all instances where H2 (and on down) = NO and I2 (and on down) is non blank? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering by row | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |