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.)
This post is excerpted with permission from Excel.Tips.Net
Subscribe to the Free ExcelTips Newsletter with the links below