Hello,

I am looking for a formula or a macro that will allow me to determine when the same number appear more than ten time consecutively. For example:
1 2 3 1 1 1 1 1 1 1 1 1 1 1 4 3 -> = 1 (more than ten times consecutively)
1 1 1 1 2 1 1 1 1 3 1 1 1 1 4 2 -> = 0 (less than ten times consecutively)

As you can see, I am not looking for a frequency.
The formula should work for the following numbers : -77, 1, 2, 3, 4, 5, 6, 7
and for blocs of 20 columns.

Thanks for your help!
Best