Highlight duplicate values in a report column | Community
Skip to main content
A
AbhipsitaBo
Level 2
August 18, 2020
Question

Highlight duplicate values in a report column

  • August 18, 2020
  • 1 reply
  • 643 views

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.

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    August 18, 2020

    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

      A
      AbhipsitaBoAuthor
      Level 2
      August 18, 2020

      Thanks Doug Thats a great workaround.

      Terms & ConditionsAccessibility statement

      Loading footer...