Excel Remove Duplicate

Automatically remove duplicate values from a data set.

remove duplicate

The above list contains duplicate values due to a download error, the duplicate values can be removed automatically using the function below.

remove duplicate

Highlight the Cells B3:C21 and select the Remove Duplicates button highlighted below that can be found on the “Data” tab.

remove duplicate

Select the colum that you wish to remove duplicates from and hit “OK”

remove duplicate

Excel will then inform you of the number of duplicate values that have been removed and how many unique values remain.

remove duplicate