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