In Excel, there are several ways to filter for unique values—or remove duplicate values:
- To filter for unique values, click Data > Sort & Filter > Advanced.
- To remove duplicate values, click Data > Data Tools > Remove Duplicates.
To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
