Filter for unique values or remove duplicate values from Excel OR CSV

By | August 28, 2019
Spread the love

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.
    The Sort & Filter group on the Data tab
  • To remove duplicate values, click Data > Data Tools > Remove Duplicates.
    Remove Duplicates
  • To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.