How to Dedupe in Excel?

Select the range of data

Go to the Data tab

Click Remove Duplicates

Choose the columns to check for duplicates

Check or uncheck My data has headers as needed

Click OK

Review the results

Save the workbook

Suggested for You

Trending Today