To remove duplicate rows we can use the standard Excel functionality Remove duplicates. We can remove or replace duplicates in one column or in several columns.
This step by step tutorial will assist all levels of Excel users in learning how to remove duplicate rows.
Remove Duplicate Rows One Column
If we want to remove duplicate rows in a single column, we need to select the column and choose Remove duplicates button in the Data tab.
Figure 1. Data for removing duplicates example
Now, we need to go to the Data tab and click on the Remove duplicates icon:
Figure 2. Choose the Remove duplicates option
Then, we need to select the column in the selected range where we want to remove duplicate rows. As we selected only one column, it will be automatically selected:
Figure 3. Choose the column for removing duplicate rows
We have the name John repeated in rows 3, 6 and 10, the function will keep the first value in row 3 and remove duplicate rows 6 and 10:
Figure 4. The result of the Remove duplicates option
Remove Duplicate Rows Multiple Columns
We can also delete duplicate rows, comparing values in two or more columns. In this example, we have names in column B and surnames in column C. We want to delete all rows which have the same values in both columns.
Figure 5. Data for removing duplicates example
First, we need to select both columns and go to the Data tab and click on the Remove duplicates icon:
Figure 6. Choose the Remove duplicates option
Now, we need to select columns in the selected range where we want to remove duplicate rows. As we want to compare both name and surname, we will select columns B and C:
Figure 7. Choose columns for removing duplicate rows
Figure 8. The result of the Remove duplicates option
Name and surname John Jackson appears in rows 6 and 10, so row 6 is kept, while row 10 is removed.