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.