This example will teach you how to remove duplicates in Excel. If you just need to find duplicates, then follow this link.
- Select any cell from the dataset.
- On the Advanced tab Data (Data) click the button Remove Duplicates (Remove Duplicates). A dialog box of the same name will appear.
- Leave all checkboxes and click OK.
Result: Excel removes all duplicate rows (circled in blue) except for the first identical row it finds (marked in yellow).
To remove rows with the same values only in certain columns, follow the instructions below:
- For example, let’s delete rows with the same last name (Last Name) and country (Country).
- In the dialog box Remove Duplicates (Remove Duplicates) check the boxes next to Last Name и Country and press OK.
Result: Excel deletes all rows with the same last name and country (circled in blue) except for the first match it finds (marked in yellow).