Filter for unique values or remove duplicate values
Excel for Office 365 Excel for the web Excel 2019 Excel 2016 Excel 2013 Excel 2010 More...
WindowsWeb
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.
Learn about filtering for unique values or removing duplicate values
Filter for unique values
Remove duplicate values
Problems removing duplicates from outlined or subtotaled data
Conditionally format unique or duplicate values
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.