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 > Data Tools > Remove Duplicates. To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.