Ten Minute Guide to Excel 97

Finding Data with a Data Form

To find records in a database, you use the Criteria Form, in which you tell Excel the specific information or range of information you want to find—the criteria. You can look for something specific, such as a person with the last name of Brown, or you can look for a condition that must be evaluated, such as all records containing sales amounts less than $1000. Table 26.1 shows the operators you can use for comparisons.

Table 26.1. Excel's Comparison Operators

Operator	Meaning
=	Equal to
>	Greater than
<	Less than
>=	Greater than or equal to
<=	Less than or equal to
<>	Not equal to

For example, if you wanted to search for records containing sales amounts greater than $1000, you would enter > 1000 in the Sales field in the criteria ...