Remove duplicates in a column

Select the cell range where you want to remove the duplicates.

Go to Data and then   Remove Duplicates in the Data Tools group.

If you get a warning dialog, choose whether to expand your selection or continue. 

Select all the columns with duplicates and select OK.

Select the cell range where you want to remove the duplicates.

Go to Data and then   Remove Duplicates in the Data Tools group.

If you get a warning dialog, choose whether to expand your selection or continue. 

Select all the columns with duplicates and select OK.