Forum Discussion

sgsmanian1972's avatar
sgsmanian1972
Copper Contributor
Aug 14, 2020

TO FIND OUT DIFFERNT VALUES IN AN ARRAY OF TWO COLUMNS

I wanted to find out the different value in the second column if there are repetitions in the first column.

For example

a - 1

a - 2

 

office 365
  • Sudharsan K's avatar
    Sudharsan K
    Steel Contributor
    Aug 15, 2020
    Hi, I think you should give us more details on what you are trying to achieve and how you are trying to achieve whether via out-of-box or custom coding.
    • NewelleNielsen8821's avatar
      NewelleNielsen8821
      Copper Contributor
      Feb 28, 2022
      I have this same question, Ihave a row of data that I'm trying to see if all are the SAME, but standard if statement I can only compare two at a time - tried to configure an XLookup but not getting it.

      The Example below I want a "FAIL" because they are not all the same.

      Know its a fairly simple one but brain just isn't getting it today. Thanks!
      Preventive Care/Screening/Immunization
      $0
      $0
      $25
      $0
      $0
      $0
      $0
      $0
      $0
      $0

Resources