Today we will read in this tutorial how to remove duplicates in Excel. Go here only to find duplicates.
Click on one of the cells inside the data set —> On the Data tab, in the Data Tools group, click Remove Duplicate (a dialog box appears.) —> Leave all the check boxes checked and click OK —> Excel removes all the same rows (blue) except the first one row (yellow).
Follow the steps which is given in the snapshot
How to remove duplicates in Excel 1
To remove rows with the same value in some columns, perform the following steps.
For example, delete rows with the same last name and country —> Check last name and country and click OK.
Excel removes all rows with the last name and country (blue) except for the first found (yellow).
Follow the steps which is given in the snapshot
