Excel.Tips.Net: Filtering Columns for Unique Values

By Allen Wyatt for Excel.Tips.Net

Filtering Microsoft Excel Columns for Unique Values

It is not unusual to acquire or develop data tables that have duplicate values in a column. If you want to see only the unique values, without the duplicates, you want to filter your data table. Excel makes this rather easy for must scenarios. For instance, let’s say you have a data table in which you have part numbers in column A. If you want to filter the list so you see only unique part numbers, you can follow these steps:

1. Select one of the cells in the list of part numbers.
2. Display the Data tab of the ribbon.
3. Click Advanced Filter within the Sort & Filter group. Excel displays the Advanced Filter dialog box. (See Figure 1.)

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

50 total views, 1 views today

(Visited 4 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.