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.
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
Then the program will delete the duplicate data. And informed that the result was found 5 duplicate and deleted 5 unique information left
The result after removing the duplicate data with the Remove Duplicates command