Hi,

I was trying to see the values only if the same value arrived more than three times in the given range.

Ex:

A B C D E F G H I J
1 A A A A B A A
2

in the given range A1:J1, I would like to count 'A' only if it repeats more than or equal to 3 times. For row 1 I should get count as 4.

Can someone please help me fixing this issue.

Regards,
Santhosh