Select the column that contains duplicates
Go to the Data tab
Click Remove Duplicates
If prompted, choose the column(s) to check
Click OK
Review the confirmation message
Save the workbook
Select the column that contains duplicates
Go to the Data tab
Click Remove Duplicates
If prompted, choose the column(s) to check
Click OK
Review the confirmation message
Save the workbook