Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Filter in two condition
Hello
Is there a way to use OR command twice in custom filter for a column: For example: "equals to" , "Material" OR "equals to", "Work" OR "equals to", "Time" Normally excel custom filter window just let me use OR command once. How can I apply it twice? (Excel version is 2003) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Filter in two condition
Not possible, you would need a help column with a formula
that does the OR comparison, then you can filter on TRUE Or you can use advanced filter -- Regards, Peo Sjoblom "Aram" wrote in message ... Hello Is there a way to use OR command twice in custom filter for a column: For example: "equals to" , "Material" OR "equals to", "Work" OR "equals to", "Time" Normally excel custom filter window just let me use OR command once. How can I apply it twice? (Excel version is 2003) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto filter with condition | Excel Discussion (Misc queries) | |||
filter with condition | Excel Discussion (Misc queries) | |||
Filter Condition | Excel Discussion (Misc queries) | |||
Custom Filter? | Excel Discussion (Misc queries) | |||
Custom Formatting: Can I set up a condition? | Excel Worksheet Functions |