Hi Everyone,
I'm looking for a formula that will calculate how many digits 0,1,2,3 repeated from the previous range.
For example,
Range Y1:AC1 contains the following:
Y1= 2
Z1= 3
AA1=1
AB1=3
AC1=1
We have the values 2,3,1,3,1 in cell range Y1:AC1
In cell range Y2:AC2 contains the following...