Advanced Filter

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.

Advanced Filtering
When working with large amounts of data, it is helpful to be able to filter that data so that you only see a subset of the whole. One of the filtering tools available in Excel is referred to as advanced filtering, and it allows you to be very specific on what you want to see in your subset of data.

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
The advanced filtering capabilities of Excel allow you to extract unique items from a data table. This is very, very helpful in any number of data-crunching scenarios. This tip explains how to create your own extract of data.

Extracting Targeted Records from a List
Got a bunch of data stored in a list on a worksheet? You can use the Advanced Filter capabilities of Excel to extract just the records you need, thereby making it much easier to manage your data.

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.