Will someone please tell me why the formulas in G:K are returning wrong values. They are suppose to count how many of the values in B:F repeat. I think it may be a format problem, but can't find it.
| Book1 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 14 | 1 | 2 | 3 | 4 | 5 | ||||||||
| 15 | 12/30/16 | 03 | 14 | 17 | 25 | 36 | 1 | 1 | 1 | 1 | 1 | ||
| 16 | 12/29/16 | 03 | 05 | 13 | 23 | 36 | 1 | 1 | 1 | 1 | 1 | ||
| 17 | 12/28/16 | 07 | 14 | 22 | 34 | 35 | 1 | 1 | 1 | 1 | 1 | ||
| 18 | 12/27/16 | 05 | 09 | 13 | 15 | 17 | 1 | 1 | 1 | 1 | 1 | ||
| 19 | 12/26/16 | 13 | 26 | 30 | 33 | 36 | 1 | 1 | 1 | 1 | 1 | ||
LAST DIGIT (2) | |||||||||||||
