IF-THEN Check four values to see if there is a match

[CriticalMass048]

Hi, all!

So what I want to do is determine if there is a match between 4 values.

For example, what I TRIED is =IF(A1<>B2<>C2<>D2,"Unique","Duplicate")

So, therefore, assuming the four values are all unique, I would get "Unique", but if any one of the four matched any one of the others, it would return "Duplicate". However, Excel doesn't seem to like my way of doing it.

I have tested it with only two values and it worked fine, but it fails if I add a third. What am I doing wrong?

Thanks!

[6StringJazzer]

That is invalid syntax. A given comparison operator can only have two operands; you can't chain them. You have to do six separate comparisons.

Please Login or Register  to view this content.

[Fluff13]

If A1 is a typo & should be A2, you could also use
=IF(SUM(COUNTIF(A2:D2,A2:D2))>4,"Duplicate","Unique")

[CriticalMass048]

Thank you both!
Yes, I made a typo. All of the values to compare are on the same row.

Fluff13, yours is easier, but it doesn't seem to work. It seems like I can't compare a Range to another Range... in each case, =SUM(COUNTIF(A2:D2,A2:D2)) gives me a result of 0.
6StringJazzer's answer will work, but it would be more difficult if I added more columns. What if I wanted to compare 7 or 8 values? That would be way too messy.

[CriticalMass048]

Ok, found it!

You were close, Fluff13! I Googled it a little further, and I found this:

=SUM(IF(FREQUENCY(G2:L2,G2:L2)>0,1))

Thank you both. I will still Upvote you both for the quick responses!

[Fluff13]

Glad you sorted it & forgot to mention that with my solution it probably needs CTRL Shift Enter rather than just Enter