Remove duplicates from an Excel list
Here’s how to remove duplicates from an Excel column in a few clicks.
- 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