Welcome!

Home
Forum Archives
Archived 2016 Posts

Using OR in filters

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

Find more posts tagged with

Comments

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