2 Replies Latest reply: Apr 13, 2016 1:50 PM by Suzanne Savage

# Filter 2 Ranges of Numbers in one Filter

Hi Folks,

I have a range of numbers from 12 to 5,000. I want to filter out numbers between 1,300 and 1840 and numbers between 3624 and 3687. I can figure out one or the other, but not both in one filter. Any suggestions would be appreciated.

Thanks!

Suzanne :-)

• ###### Re: Filter 2 Ranges of Numbers in one Filter

Hello Suzanne,

You can do this in three ways. You can make a lookup table and specify the values one by one. Or you can make multiple filters like Number<1300, Number>1840 .and. Number <3624, Number >3687, and then make a compound filter where any one of these three filters is true, or you can make a filter with one big expression:

Number<1300

.or.

(Number>1840 .and. Number<3624)

.or.

Number>3687

Hope this helps,

Olly

• ###### Re: Filter 2 Ranges of Numbers in one Filter

Thanks Olly,

This works perfectly…so logical!

Suzanne Savage

Savage Consulting Group

605 S. Gulfstream Avenue #2C

Sarasota, FL  34236

941.552.6613

suzanne@savagecg.com