Tips.Net > ExcelTips Home > Filtering
The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Filtering for Comments Excel makes it easy to filter a data table based on various values in that table. It isn’t so easy to filter according to whether a cell contains comments or not. Here’s a few ways you can make the filtering easier. Microsoft Excel versions: 97 2000 2002 2003 2007
Recalculating when Filtering Filter a large worksheet, and Excel will helpfully recalculate every time you apply a different filter. This can get bothersome, particularly if the recalculation stops you from doing what you want to do in the worksheet. There is a way to handle this, involving turning the calculation on and off, as desired. Microsoft Excel versions: 97 2000 2002 2003
Removing Duplicates Based on a Partial Match If you have a set of addresses in a worksheet, you may have some addresses that partially match other ones. For instance, a set of addresses where the only differences are the apartment or suite number. This tip explores different ways you can remove or identify duplicates in the addresses based on only a part of that address, such as the street name and number. Microsoft Excel versions: 97 2000 2002 2003
Sorting or Filtering by Conditional Format Results Conditional formatting is a great feature in Excel. Unfortunately, you can’t sort or filter by the results of that formatting. Here’s why. Microsoft Excel versions: 97 2000 2002 2003 2007
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site