| Comparison Term |
Description |
| Not blank |
The specified column has information in it. |
| Greater than |
Searches columns with numerical information. Numbers in the specified column are greater than the number entered in the text box. |
| Contains |
Text or numbers in the specified column must match any part of the text or numbers entered in the text box. |
| Blank |
The specified column is empty. |
| After |
Searches columns with alphabetical information. Text in the specified column must start with words/letters that occur alphabetically after the words/letters entered in the text box. |
| Before |
Searches columns containing alphabetical information. Words in the specified column must start with words/letters that occur alphabetically before the word/letter entered in the text box. |
| Equals |
Content of the specified column must match exactly with the text or numbers entered in the text box |
| Starts With |
Text in the specified column must start with the letter entered in the text box. |
| Ends With |
Text in the specified column must end with the letter entered in the text box. |
| Less Than |
Searches columns with numerical information. Numbers in the specified column must be smaller than the number entered in the text box. |