All numbers except zero. Not that <> cannot be used in conjunction with other wild cards such as *

And

&

<2000&>1000

Numbers that are less than 2000 AND greater than 1000

The & sign must be used with a range because no single record can have two values. An example of an invalid use of & is A&B - because no records can be equal to A *AND* equal to B. An example of a valid use of & is A*&*B, which means 'find all records that start with A and end with B'.

Or

|

1200|1300

Those with number 1200 OR 1300

Greater than

>

>1200

Numbers greater than 1200

Greater than or Equal to

>=

>=1200

Numbers greater than or equal to 1200

Less than

<

<1200

Numbers less than 1200

Less than or Equal to

<=

<=1200

Numbers less than or equal to 1200

Interval

..

1100..2100

..2500

..12/31/2019

8..

Number between 1100 and 2100 (inclusive)

All number up to and including 2500

All dates up to and including December 31, 2019

Everything 8 or higher

Indefinite number of unknown characters

*

*Co*

*Co

Co*

Text that contains "Co"

Text than ends with "Co"

Text that begins with "Co"

One unknown character

?

Hans?n

Text such as 'Hansen' or 'Hanson'

Calculate first

()

30|(>=10&<20)

The number 30 OR with a number between 10 through 20

Ignore special characters

@@

@@A&B

Those equal to "A&B" - the & is part of the value, instead of being interpreted as the AND operator (listed above)

"@@"&

"@@"&C3

or

""&C3&""

or

""&C3&"|"&C4&""

where C3 and C4 could contain blank or special characters such as: "John(Huston)", "Ben & Jerry's"

Use "@@"& <Cell Reference> if the cell reference could be blank and you want to filter for blank field values.

Use the ' character in double quotes added before and after a cell reference to always have a safe filter from the cell reference.

The two methods listed above are equivalent for a single filter. If you want to combine two cells with filters in them, you must use the technique shown in the bottom example.

Ignore case (upper or lower)

@

@location

Text such as "Location", "LOCATION", "locatioN", etc.

You can also combine the various filter expressions as in the following table.

Example

Results

5999|8100..8490

Include all records with the number 5999 OR a number from 8100 through 8490

..1299|1400..

Include records with a number less than or equal to 1299 OR a number equal to or greater than 1400 (i.e., all numbers except 1300 through 1399)

>50&<100

Include records with numbers that are greater than 50 AND less than 100 (i.e., 51 through 99)