Highlight duplicate values in a report column | Community
Skip to main content
AbhipsitaBo
Level 2
Aug 18, 2020 5:02 PM UTC
Question

Highlight duplicate values in a report column

Hi,

Is there a way to highlight the duplicate values in a column. Similar to excel conditional formatting > Highlight duplicate values

In simple words, if a column has the value “231” twice then it will be considered as duplicate.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    Aug 18, 2020 6:27 PM UTC

    Hi Abhipsita,

    Not that I'm aware of -- conditional formatting is restricted to "that row" independent of any others and does not account for aggregates -- but instead, you could group by the column in question, return all rows, and search the page for (2), (3), (4) etc to "find" any with more than (1) in the group.

    Regards,

    Doug

    Translate
      AbhipsitaBoAuthor
      Level 2
      Aug 18, 2020 8:03 PM UTC

      Thanks Doug Thats a great workaround.

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...