R1 R F
R 2 4
F 1 0
The formula for above format.
=IFERROR(MATCH(1,(SKIPSUMS!$AG$21:$AG$6631=$A17)*(SKIPSUMS!$AG$22:$AG$6630=B16),0)-1,"")
I would like the formula to be in this format.
R 2 4
F 1 0
The formula for above format.
=IFERROR(MATCH(1,(SKIPSUMS!$AG$21:$AG$6631=$A17)*(SKIPSUMS!$AG$22:$AG$6630=B16),0)-1,"")
I would like the formula to be in this format.
| Book1 | |||||
|---|---|---|---|---|---|
| CM | CN | CO | |||
| 1 | F2R1 | F | R | ||
| 2 | |||||
| 3 | PKG | 0 | 0 | ||
| 4 | HITS | 494 | 505 | ||
| 5 | MED | 1 | 1 | ||
| 6 | MAX | 10 | 10 | ||
| 7 | AVG | 2.02 | 1.98 | ||
| 8 | CUR SKIP | 10 | 0 | ||
| 9 | PREV SKIP | 5 | 1 | ||
| 10 | 3 | 2 | 1 | ||
| 11 | 4 | 1 | 1 | ||
| 12 | 5 | 1 | 1 | ||
RPTS FLIPS | |||||
| Book1 | ||||
|---|---|---|---|---|
| B | C | |||
| 16 | R | F | ||
| 17 | 2 | 4 | ||
| 18 | 1 | 0 | ||
FOLLOWERS | ||||
Last edited:
