Remove Duplicates in Excel
This tutorial shows how to remove duplicates in Excel. An important trick to save tons of time when working with huge data.
Description of Example
We have a simple table of population for each city. It can be noticed that there are duplicate data for the city of London in this table. The objective is to remove these duplicated entries and keep only one row of data. The desired result are highlighted in blue box in below figure.
How is it done
Step 1. Select the table
Step 2. Go to Data > Remove Duplicates
Step 3. A small window will come out as shown below. Select the columns by which duplicates will be checked, then press 'OK'.
See below figure.
Step 4. A confirmation message will pop out like as shown below. Press 'OK' and viola, you will now have a free-duplicate data.
These steps are summarized in the following screen recording.
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.