As we want to compare both name and surname, we will select columns B and C:įigure 7. Now, we need to select columns in the selected range where we want to remove duplicate rows. Data for removing duplicates exampleįirst, we need to select both columns and go to the Data tab and click on the Remove duplicates icon:įigure 6. We want to delete all rows which have the same values in both columns.įigure 5. In this example, we have names in column B and surnames in column C. We can also delete duplicate rows, comparing values in two or more columns.
The result of the Remove duplicates option Remove Duplicate Rows Multiple Columns 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:įigure 4. Choose the column for removing duplicate rows As we selected only one column, it will be automatically selected:įigure 3. Then, we need to select the column in the selected range where we want to remove duplicate rows. Now, we need to go to the Data tab and click on the Remove duplicates icon:įigure 2. 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.įigure 1.
#Excel remove duplicate rows how to#
This step by step tutorial will assist all levels of Excel users in learning how to remove duplicate rows. We can remove or replace duplicates in one column or in several columns. To remove duplicate rows we can use the standard Excel functionality Remove duplicates.
0 kommentar(er)
