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

2. Hacking Excel’s Built-in Features > 31. Manipulate Data with the Advanced Fi...

Manipulate Data with the Advanced Filter

If you are familiar with Excel’s AutoFilter tool, you also are familiar with its limitations. If you require extensive data manipulation, using Excel’s Advanced Filter tool is the way to go.

Although limited, AutoFilters are a useful way to display only the data that meets particular criteria. Sometimes, however, you cannot glean the information you need using the standard options available in AutoFilters. Excel’s versatile Advanced Filter tool enables you to further manipulate your data.

When you use Excel’s Advanced Filter tool, your table must be set up in a classic table format as described at the start of Chapter 1.

When using Excel’s Advanced Filter tool, you will need a copy of your table’s column headings somewhere above your data. You should always leave at least three blank rows above your table of data. To ensure that your headings are exactly the same and will remain so regardless of whether you change your column headings, always reference the column headings with a simple reference formula such as


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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