Filtering

Tips, Tricks, and Answers

The following articles are available for the 'Filtering' topic. Click the article's title (shown in bold) to see the associated article.

Counting Filtered Rows
The filtering capabilities of Excel are indispensable when working with large sets of data. When you create a filtered list, you might want to know how many rows are displayed in that list. Here's a variety of methods you can use.

Filtering Columns
The filtering tools provided in Excel make it easy to filter a data list so that only certain rows are displayed. What if you want to filter your information so that only certain columns are displayed, however? Excel doesn't provide a direct way to do this, but there are several workarounds you can adapt to your needs.

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.

Hiding Graphics when Filtering
Excel allows you to set up graphics so that they are associated with cells and even stay with the cells when the cells are sorted. But what about when you filter the list? Here's how to make sure that the graphics are no longer visible when the list is filtered.

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.

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.

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.

More Information

The following are additional topics related to the subject of 'Filtering'. A bracketed number after the topic indicates how many articles are related to that subject.