User Tools

Site Tools


In Excel, you have several ways to filter for unique values or remove duplicate values:

  • To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.
  • To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.
  • To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
duplicates.txt · Last modified: 2017/10/20 16:17 by zeppo