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. | ||
