How To Remove Duplicates In Excel Column?

Select the column with duplicates

Go to the Data tab

Click Remove Duplicates

Check the correct column

Click OK

Review the confirmation message

Click OK to finish