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.
2. Then select the data including the formula column, click Data > Remove Duplicates, then click OK in Remove Duplicates dialog.
3. A dialog pops out to remind you the number of removing rows. Click OK to close it.
Now the duplicates have been removed but keep blank rows. You can remove the helper column.
