Highlight Duplicate Records

❓ Questions & help
1

How one can highlight duplicate record?

2

Welcome to the community @Aleksey_Krylov !

  1. You can use a column formula to flag the dupes as TRUE/FALSE
    image
    image571Γ—703 31 KB

As for highlighting, we are very close to releasing our Conditional formatting feature - we should be rolling it out in a few weeks. - In Nov/21.

  1. With conditional formatting, you should be able to highlight all rows with Dup values. I’m including a screenshot from the feature which is in QA.

**

image
image1339Γ—759 77.9 KB

**

3 Likes
3

Hi Murali, thanks for above details to identify duplicates.
As next steps, is it possible to automatically to flag latest record i.e by comparing the β€˜Updated at’ field?

This will help in retaining only one record and move the rest.

4

You can define another column formula, to flag only the latest row among duplicates & also all unique rows.

image
image1588Γ—768 86.1 KB

4 Likes
5

Thanks a lot msiraj. It helped me. I have used below logic to identify and move duplicates. IF(COUNTIF(A:A,A)>1,IF(MINIFS(K:K,A:A,A)=K,TRUE,NULL),NULL)

MINIFS to identify old record and MAXIFS to identify latest record.

1 Like
6

We are likely to introduce Formula based Rules (formula evaluates to TRUE) to do conditional formatting. That would avoid the need to make these intermediate result columns.

1 Like