> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/remove-duplicates.md).
# 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**
{% file src="/files/-LRb1eBFdK6jgqytBMmu" %}
Example of Remove Duplicates
{% endfile %}