Custom Filter in two condition

A

Aram

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
 
P

Peo Sjoblom

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
 
Top