Tips, Tricks, and Answers
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.