Filter/Identify Unique Values or Remove Duplicate Values

Filter Identify Unique Values or Remove Duplicate Values

Filter/Identify Unique Values or Remove Duplicate Values

Filter/Identify Unique Values or Remove Duplicate Values

In Microsoft Office Excel 2007, you have several ways to Filter for Unique Values or Remove Duplicate Values, 3 most commonly used options are listed below:

1 > To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.

2 > To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.

3 > To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.

Let us know if you have a better & simple solution..

Show Comments

No Responses Yet

Leave a Reply