2

In the example below, I want to count all of the duplicates in the range A2:I2 and if there are more than three of the same occurrence, true else false I tried >3assuming it would show true if the count of unique values were greater than three.

In the image below the formula would return true since there are more than three occurrences of any text value in the range A2:I2

=SUMPRODUCT(COUNTIF(A2:I2,A2:I2))>3

enter image description here

Improve this question

1 Answer 1

Reset to default
3

put the >3 inside the SUMPRODUCT:

=SUMPRODUCT(--(COUNTIF(A2:I2,A2:I2)>3))>0

Now it will return True if any one value is there more than 3 times.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .