How to delete duplicate data in Excel with the Remove Duplicates command, a command that allows us to quickly delete duplicate data. In working with data, sometimes the information that is obtained does not match our needs. And frequent problems Is the data problem itself, which Microsoft Excel has a function to handle these duplicate data for us

Let's get started

Click the column that you want to delete duplicates and go to the Data tab => at the Data Tools group. Click Remove Duplicates.

how to remove duplicates in excel

At the Remove Duplicates window, click to select column of data you want to delete, check Column A and check My data has headers. Then click OK button

how to remove duplicates in excel

Then the program will delete the duplicate data. And informed that the result was found 5 duplicate and deleted 5 unique information left

how to remove duplicates in excel

The result after removing the duplicate data with the Remove Duplicates command

how to remove duplicates in excel