Need an formula to track the number of draws a value follows another value.

[CARBOB]

The formulas in columns Q2-T5 tracks number of times the values in column U and V1-Y1 have followed the values in in columns V1-Y1. Formulas in Q7-T10 tracks skips. I am not sure if sure if values are correct because of the formats of the value as 2-digit values.

Book1
	P	Q	R	S	T
1	F1R1	00	01	10	11
2	00	385	453	443	440
3	01	445	446	447	408
4	10	427	449	465	405
5	11	382	367	397	433
6	F1R2	00	01	10	11
7	00	5	38	2	34
8	01	4	12	20	10
9	10	33	3	7	0
10	11	1	11	50	16
11		00	01	10	11
FOLLOWERS

Cell Formulas
Range	Formula
Q1	=$V$21
Q2	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$V$21:$V$6631=$P2),(--(SKIPSUMS!$V$20:$V$6630=Q$1))))),"")}
Q3	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$V$21:$V$6631=$P3),(--(SKIPSUMS!$V$20:$V$6630=Q$1))))),"")}
Q4	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$V$21:$V$6631=$P4),(--(SKIPSUMS!$V$20:$V$6630=Q$1))))),"")}
Q5	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$V$21:$V$6631=$P5),(--(SKIPSUMS!$V$20:$V$6630=Q$1))))),"")}
Q7	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P7)*(SKIPSUMS!$V$22:$V$6630=Q$6),0)-1,"")}
Q8	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P8)*(SKIPSUMS!$V$22:$V$6630=Q$6),0)-1,"")}
Q9	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P9)*(SKIPSUMS!$V$22:$V$6630=Q$6),0)-1,"")}
Q10	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P10)*(SKIPSUMS!$V$22:$V$6630=Q$6),0)-1,"")}
R2	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$W$21:$W$6631=$P2),(--(SKIPSUMS!$W$20:$W$6630=R$1))))),"")}
R3	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$W$21:$W$6631=$P3),(--(SKIPSUMS!$W$20:$W$6630=R$1))))),"")}
R4	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$W$21:$W$6631=$P4),(--(SKIPSUMS!$W$20:$W$6630=R$1))))),"")}
R5	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$W$21:$W$6631=$P5),(--(SKIPSUMS!$W$20:$W$6630=R$1))))),"")}
R7	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P7)*(SKIPSUMS!$V$22:$V$6630=R$6),0)-1,"")}
R8	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P8)*(SKIPSUMS!$V$22:$V$6630=R$6),0)-1,"")}
R9	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P9)*(SKIPSUMS!$V$22:$V$6630=R$6),0)-1,"")}
R10	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P10)*(SKIPSUMS!$V$22:$V$6630=R$6),0)-1,"")}
S2	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$X$21:$X$6631=$P2),(--(SKIPSUMS!$X$20:$X$6630=S$1))))),"")}
S3	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$X$21:$X$6631=$P3),(--(SKIPSUMS!$X$20:$X$6630=S$1))))),"")}
S4	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$X$21:$X$6631=$P4),(--(SKIPSUMS!$X$20:$X$6630=S$1))))),"")}
S5	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$X$21:$X$6631=$P5),(--(SKIPSUMS!$X$20:$X$6630=S$1))))),"")}
S7	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P7)*(SKIPSUMS!$V$22:$V$6630=S$6),0)-1,"")}
S8	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P8)*(SKIPSUMS!$V$22:$V$6630=S$6),0)-1,"")}
S9	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P9)*(SKIPSUMS!$V$22:$V$6630=S$6),0)-1,"")}
S10	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P10)*(SKIPSUMS!$V$22:$V$6630=S$6),0)-1,"")}
T2	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$Y$21:$Y$6631=$P2),(--(SKIPSUMS!$Y$20:$Y$6630=T$1))))),"")}
T3	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$Y$21:$Y$6631=$P3),(--(SKIPSUMS!$Y$20:$Y$6630=T$1))))),"")}
T4	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$Y$21:$Y$6631=$P4),(--(SKIPSUMS!$Y$20:$Y$6630=T$1))))),"")}
T5	{=IFERROR(1/(1/(SUMPRODUCT(--(SKIPSUMS!$Y$21:$Y$6631=$P5),(--(SKIPSUMS!$Y$20:$Y$6630=T$1))))),"")}
T7	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P7)*(SKIPSUMS!$V$22:$V$6630=T$6),0)-1,"")}
T8	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P8)*(SKIPSUMS!$V$22:$V$6630=T$6),0)-1,"")}
T9	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P9)*(SKIPSUMS!$V$22:$V$6630=T$6),0)-1,"")}
T10	{=IFERROR(MATCH(1,(SKIPSUMS!$V$21:$V$6631=$P10)*(SKIPSUMS!$V$22:$V$6630=T$6),0)-1,"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[CARBOB]

Solved issue.