Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)