How To Delete Duplicates In Excel?

Select the range or columns where you want to remove duplicates

Go to the Data tab

Click Remove Duplicates

If needed, confirm which columns to check in the dialog box

Click OK

Review the results message

(Optional) If you need to keep the first occurrence, use the default behavior; if not, sort the data first, then remove duplicates

Suggested for You

Trending Today