Remove duplicates from an Excel list

Here’s how to remove duplicates from an Excel column in a few clicks.

Removing Duplicates

  • Select the range of cells or column
  • On the Data tab, click Remove Duplicates
  • Click OK
  • A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.

Bonus Tip:  To do this in Google sheets uses =UNIQUE() to create a new list with a unique set of records