Microsoft Office Tutorials and References
In Depth Information
Specifying a single criterion
The examples in this section use a single-selection criterion. In other words, the contents of a single field de-
termine the record selection.
You also can use standard filtering to perform this type of filtering.
To select only the records that contain a specific value in a specific field, enter the field name in the first row of
the criteria range and the value to match in the second row.
Note that the criteria range does not need to include all the fields from the database. If you work with different
sets of criteria, you may find it more convenient to list all the field names in the first row of your criteria range.
Using comparison operators
You can use comparison operators to refine your record selection. For example, you can select records based on
any of the following single criteria:
• Homes with at least four bedrooms
• Homes with square footage less than 2,000
• Homes with a list price of no more than $250,000
To select the records that describe homes that have at least four bedrooms, type Bedrooms in cell A1 and then
type >=4 in cell A2 of the criterion range.
Table 9-2 lists the comparison operators that you can use with text or value criteria. If you don't use a comparis-
on operator, Excel assumes the equal sign operator (=).
Table 9-2: Comparison Operators
Greater than or equal to
Less than or equal to
Not equal to
Using wildcard characters