Filter for unique values or remove duplicate values

In Excel, there are several ways to filter for unique values—or remove duplicate values:

To filter for unique values, select Data > Sort & Filter > Advanced.

To remove duplicate values, select Data > Three dots > Remove Duplicates.
To highlight unique or duplicate values, from the Home tab, click Three dots, use the Conditional Formatting command in the Style group.