• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 26. Finding and Sorting Data in a... > Finding Data with a Data Form

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
OperatorMeaning
=Equal to
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
<>Not equal to



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint