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

Lesson 29. 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 Brown, or you can look for a condition that must be evaluated, such as all records containing sales amounts less than $1,000. Table 29.1 shows the operators you can use for comparisons.

Table 29.1. Excel's Comparison Operators
OperatorMeaning
=Equal to
>Greater than
<Less than
Greater than or equal to
Less than or equal to
≠fsNot equal to



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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