Làm sao để xóa những dữ liệu trùng nhưng vẫn giữ những ô trống

Remove Duplicates Keep Blanks With Formula And Remove Duplicates

To remove duplicates keep blank rows, you need to add a helper column to identify the blank rows firstly, then apply Remove Duplicates function to remove the duplicates.

1. In the adjacent cell, type this formula =IF(LEN(TRIM(A1))=0,ROW(),””), A1 is the first data of the list you want to remove duplicates, drag the auto fill handle over cells to get all blank rows numbers.
doc remove duplicates keep blanks 2

2. Then select the data including the formula column, click Data > Remove Duplicates, then click OK in Remove Duplicates dialog.
doc remove duplicates keep blanks 3
doc remove duplicates keep blanks 4

3. A dialog pops out to remind you the number of removing rows. Click OK to close it.
doc remove duplicates keep blanks 5

Now the duplicates have been removed but keep blank rows. You can remove the helper column.
doc remove duplicates keep blanks 6

Leave a Comment

Your email address will not be published. Required fields are marked *