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

Chapter 38. Finding, Filtering, and Edit... > Using the Advanced Filter

Using the Advanced Filter

Although using the Data, Filter, Advanced Filter command involves more work than using the data form or AutoFilter, the command enables you to search for data that must match calculated criteria or matches involving complex AND and OR criteria. In addition, the command prepares you to use more powerful features, such as extracting a copy of filtered data from a list. The command also uses the same concepts required for using Excel's analysis functions and data tables as described in Chapter 25, "Manipulating and Analyzing Data." It also uses similar criteria concepts to those used by Microsoft Query, as in Chapter 40, "Retrieving Data from External Databases," to link Excel to external databases.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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