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 Value
text box.
|
| Contains |
Text or numbers in
the specified column must match any part of the text or numbers
entered in the Value 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 Value
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 Value
text box. |
| Equals |
Content of the specified
column must match exactly with the text or numbers entered in the
Value
text box. |
| Starts with |
Text in the specified
column must start with the letter entered in the
Value 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 Value
text box. |