TO FIND OUT DIFFERNT VALUES IN AN ARRAY OF TWO COLUMNS

[sgsmanian1972]

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

[#2]

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.

[#3]

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