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!