0

Filter to exclude a range

Joanne Chong

April 26, 2022 15:04

None

Follow

In the nl (rows) filter, how to exclude say a range of numbers. I tried <>2800..3000. It prompt error. How can i insert that filter?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  BobRoss April 28, 2022 15:40

  Are you able to do "..2799|3001.." (up to and including 2799 or 3001 and higher)?  If you need to exclude a single value from a range of numbers, you can use the &<>#### but not a range.  Example "100..1000&<>500" = all numbers from 100 to 1000 but not 500.

• 0
  
  Joanne Chong April 29, 2022 02:27

  Thanks for the reply. will try it