Remove Duplicates

Remove Duplicates

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.

Short Key --> Alt + A + M