How to delete duplicates?

[Sheryl_D]

Hi, we have a list of data that has duplicate information in Column A. Now we want to remove the duplicates and just leave the word that has the highest number in column C and the lowest number in Column D but there are instances where column C or D maybe the same.

Please check the image below. So for the case of “Rose”, we just want to leave the first “Rose” with the highest number in column C and Lowest number in Column D and filter out the other “Rose” on the list.

[msiraj]

• First, to identify duplicates, you can consider the following solution. Define a column formula that marks each row with a boolean flag. TRUE indicating its uniqueness fulfilling a specific set of criteria, FALSE identifying it as a duplicate.

Eg: AND(MAXIFS(B2:B,A2:A,A)=B,MINIFS(C2:C,A2:A,A)=C)

• With conditional formatting you can also highlight such rows, leveraging the boolean flag on each such row.

• You can also define a new view to only list the unique rows.

• Similarly you can also define a view to only list duplicate rows which you can then review & cleanup in bulk.