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

Chapter 13. Analyzing Data with Lists > Setting Up a Criteria Range

Setting Up a Criteria Range

Before you can work with complex criteria, you must set up a criteria range. A criteria range has some or all of the list field names in the top row, with at least one blank row directly underneath. You enter your criteria in the blank row below the appropriate field name, and Excel searches the list for records with field values that satisfy the criteria. This setup gives you two major advantages over AutoFilter:

  • By using either multiple rows or multiple columns for a single field, you can create compound criteria with as many terms as you like.

  • Because you're entering your criteria in cells, you can use formulas to create computed criteria.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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