Highlight duplicate cell and filter by color

Tags: #<Tag:0x00007efc64499c80>
#1

hi , is there anyway we can highlight duplicates cells and filterby colors.

#2

Hi @MZ1000_1

there’s no built-in functionality to detect duplicates. Have you already created the script to detect them?

#3

No , you have any script with you

#4

First, we need to define if a duplicate is

  • the same value is a column
    image
  • the same value in a row
  • the same value in a table
  • the same row data
  • the same column data

All those cases require a different condition to be used.

Column should not allow duplicate value
#5

Is it possible to add these Built In function?

#6

For sure. However, I do not see this functionality on our list for Q4 of 2020, and the Roadmap for 2021 is not yet created. Still, as mentioned in my ticket above it is possible by the use of our API - it just requires a bit more coding.

#7