Using OR in filters

Alex Cleater

Is there a way of using OR when applying filters to a column? Currently if I try mulitple criteria, it seems to apply AND, which doesn't work for my particular filtering needs.

 

Thanks all.

Alex

 

Atus Bartal

Alex,

I also had this issue a couple of weeks ago. What helped me is kind of "negative" filtering: I chose "not equal to" twice, then clicked on the "Exclude selected items" checkbox. It gave me the values next to the "not equal to" options. 

I hope it helps.

Atus

J. Craig Williams

If this is a filter you use often, then I would make a column for it.

Here's the formula for an OR using NOT and AND.

 

=NOT(AND(NOT([Chk1]23), NOT([Chk2]23)))

 

Craig

Alex Cleater

Thanks Atus and Craig. I'll give this a go.

 

Alex