Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
There may be a time when the basic capabilities of Excel's AutoFilter tool are not enough to accomplish the task at hand. Fortunately, you can take filtering to another level if you just instruct Excel to filter a certain way. Use the following articles to learn what you can do in Excel with advanced filtering.
The following articles are available for the 'Advanced Filter' topic. Click the article's title (shown in bold) to see the associated article.
Many people know how to use AutoFilter, but there are times when you need some more filtering muscle. Here's how you can use Excel's advanced filtering capabilities to see only the parts of your data that you need to see.
Copying Comments when Filtering
The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.
Copying the Results of Filtering
Filtering is a great asset when you need to get a handle on a subset of your data. Excel even makes it easy to copy the filtered data to another location, as described here.
Extracting Targeted Records from a List
When working with large amounts of data, you may have a need to extract just the information that meets the criteria you specify. Excel provides the built-in tools that make this task easy.
Performing Calculations while Filtering
The advanced filtering capabilities of Excel allow you to easily perform comparisons and calculations while doing the filtering. Setting up the filter is easy, as described in this tip.