Filter dialog box

Use the Filter dialog box to display only those rows that match the specified criteria, hiding the items that do not match.

In contrast, Find highlights items while showing all items.You can filter as follows:

Basic: Finds a value in any field in the display.
Advanced: Finds the values in an individual field or in fields using advanced criteria (AND/OR) and comparisons (equal to, less than, more than, contains, and so on). If you know in which column the data is found, using the Advanced tab may be faster. When using the Basic tab, every column of every row is searched until a match is found.

To filter

Select a tab, enter search terms, and select search options, then click Filter.

Table: Filter dialog box options shows the options available in the Filter dialog box.

Table: Filter dialog box options

Option	Description
Add to List	Adds the criteria to the criteria list. All items in the criteria list are used for the find operation.
Comparison	The type of comparison for the search.
Contains	The string you entered can appear anywhere in the item.
Field	The name of the column you want to search.
Filter previous results	Check to refilter the table with additional criteria. If this is not checked, the filter acts on the unfiltered table.
Find text in table	The alphabetic or the numeric string for which you are searching.
Is exactly	The string you entered must be identical and in the same order.
Match case	Performs a case-sensitive comparison. Often, using Match case speeds up the filtering.
Matches items that contain all of the criteria (AND)	Performs a search in which all defined criteria must match.
Matches items that contain at least one of the criteria (OR)	Performs a search in which only one of the criteria must match.
Remove	Deletes the selected filtering criteria.
Show no matches (items not matching criteria)	Performs a search for those items that do not match the filtering criteria. (Filter out the data specified.)
Starts with	The string you entered must appear at the beginning of the item.
Value	The alphanumeric string for which you are searching. If the column displays numeric data, you can use the number spinner to select a value.