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..

Leave a Reply

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

one × three =

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