Count to 3 return 1

[deciog]

When column "C" contains the same letter in sequence, count to a maximum of 3 and start counting again

Decio

 

[bosco_yip]

For comparison purpose, the formula put in C2 and copied down :



=IF(A1=A2,IF(C1=3,1,C1+1),1)

Regards
Bosco

 

[deciog]

Our head is breaking and it's so simple.

Many thanks Bosco

 

[p45cal]

A variation, for the heck of it:
=IF(A1=A2,MOD(C1,3)+1,1)

 

[deciog]

p45cal

Very good, too. I liked it.

Decio

 

[John Jairo V]

Hi, to all!

Another option could be:
[C2] : =1+(A1=A2)*MOD(N(C1),3)

Blessings!