How to return True if at least two out of n cells match?

[danilidimi]

Hello,

I'm trying to weed out situations where at least two cells match; altogether the formula needs to be flexible to account to many cells.

Example attached. I'm trying to rank players by highest number of points. Need to avoid the situation in row 10 where Sean and Michael have the same points.


Please only help on "how to return True if at least two out of n cells match" - I've been stuck on this for a while but want to figure out the rest myself!


Cheers,
D

[davsth]

where do you want to return true?

as an array with shift control enter
=SUM(COUNTIF(A10:C10,A10:C10))/COUNT(A10:C10)>1

SUM(COUNTIF(A10:C10,A10:C10)) should equal COUNT(A10:C10) if all values are unique, as each value gets counted once in the array. If thee are duplicates it will exceed this

[Shareez Saleem]

Please Login or Register  to view this content.

[davsth]

Shareez, im not sure this works as the duplication could also be for 2nd place, if I understand the question correctly