Spreadsheet: 170614d1343331440-ranking-formula-help-query4-1-
Sheet: Sheet2

Sum of CountOfMCC_Code | Column Labels
Row Labels | 0742 | 1520 | 1799 | 3716 | 4111 | 4121 | 4131 | 4214 | 4722 | 4816 | 5045 | 5065 | 5072 | 5074 | 5192 | 5211 | 5251 | 5261 | 5271 | 5411 | 5441 | 5499 | 5511 | 5521 | 5532 | 5533 | 5571 | 5599 | 5611 | 5621 | 5651 | 5655 | 5691 | 5699 | 5712 | 5713 | 5714 | 5719 | 5722 | 5732 | 5733 | 5812 | 5813 | 5814 | 5921 | 5932 | 5933 | 5940 | 5941 | 5942 | 5943 | 5944 | 5945 | 5946 | 5947 | 5948 | 5949 | 5964 | 5968 | 5970 | 5971 | 5977 | 5983 | 5992 | 5995 | 5999 | 6010 | 6012 | 6051 | 6211 | 6300 | 7011 | 7033 | 7230 | 7298 | 7299 | 7399 | 7512 | 7531 | 7538 | 7623 | 7629 | 7922 | 7933 | 7941 | 7991 | 7997 | 8021 | 8062 | 8071 | 8111 | 8220 | 8351 | 8675 | 8699 | 8911 | 8999 | 9399 | Grand Total
[NAME] | 67 |  |  |  |  |  |  |  | 121 |  |  | 54 |  |  |  | 58 | 35 | 24 |  |  | 18 | 23 | 42 |  |  | 14 | 16 |  |  | 17 |  | 13 | 42 |  | 18 | 43 |  |  | 21 |  |  | 283 | 21 | 41 | 13 | 16 |  | 16 | 48 | 31 |  | 32 | 17 |  |  |  |  |  | 14 |  | 14 |  |  | 15 | 27 | 69 |  |  |  |  | 38 | 187 |  | 61 | 39 | 41 | 60 | 15 |  | 59 | 29 |  | 12 | 14 |  | 15 | 79 |  | 16 |  | 14 | 32 |  |  |  | 33 | 37 | 34 | 2098
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 |  | 282 |  |  | 283 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  | 54 | 1052 | 131 |  | 17 | 91 |  |  |  |  |  | 14 |  |  |  |  |  |  |  | 12 |  | 73 |  |  |  |  |  |  | 75 |  |  | 16 |  | 2221
SARA CHAMBERS | 170 |  |  |  |  |  |  |  | 222 |  |  | 26 |  |  | 13 | 18 |  |  | 19 | 42 |  | 15 | 45 |  |  |  |  |  | 31 |  | 22 |  | 58 |  | 20 |  | 37 |  |  | 53 |  | 120 |  |  |  |  |  | 52 | 11 |  |  | 35 |  |  |  |  |  |  | 13 |  |  |  |  |  |  | 41 |  |  |  |  | 92 | 156 |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  | 111 |  | 19 |  |  |  |  |  |  | 82 |  | 1566
SYBILLE MUIR | 53 |  |  |  | 18 | 20 | 127 | 29 | 134 | 13 |  |  |  |  |  | 15 | 11 |  |  |  |  |  | 109 | 17 |  | 29 |  | 34 |  | 14 |  |  |  | 24 | 32 |  |  | 14 |  |  |  | 147 | 12 |  |  |  |  |  |  |  | 22 | 43 |  |  | 83 |  |  |  | 18 |  |  |  |  |  |  | 61 |  |  | 576 |  | 82 | 324 |  | 31 |  | 11 | 48 |  |  | 67 |  |  | 21 |  |  |  | 58 |  |  |  |  | 44 |  |  |  |  |  |  | 2341
ZOE MITCHELL | 130 | 51 | 29 | 32 |  |  |  |  | 298 |  | 13 | 26 | 22 | 45 |  | 193 | 16 | 182 |  | 17 |  | 21 | 201 | 11 | 24 | 26 | 12 | 28 | 17 | 58 |  |  | 80 |  | 46 | 19 | 16 | 13 | 52 | 43 | 11 | 583 | 15 |  |  |  | 187 |  | 56 | 44 |  | 51 |  | 22 | 33 | 75 | 18 | 19 |  | 23 | 21 | 21 | 13 |  | 37 | 128 |  | 22 |  |  | 28 | 223 | 13 | 44 |  | 40 | 107 |  | 12 | 31 |  | 12 | 58 |  | 34 | 33 | 28 |  | 61 |  |  | 39 | 22 |  | 13 | 16 | 51 |  | 3965
Grand Total | 420 | 51 | 29 | 32 | 18 | 20 | 127 | 29 | 775 | 13 | 13 | 106 | 22 | 45 | 13 | 284 | 62 | 206 | 19 | 59 | 18 | 59 | 397 | 28 | 24 | 69 | 28 | 62 | 48 | 178 | 22 | 295 | 180 | 24 | 399 | 62 | 53 | 27 | 73 | 96 | 11 | 1133 | 48 | 41 | 13 | 16 | 187 | 68 | 115 | 75 | 22 | 161 | 17 | 22 | 116 | 75 | 18 | 19 | 77 | 23 | 35 | 21 | 13 | 15 | 64 | 353 | 1052 | 153 | 576 | 17 | 331 | 890 | 13 | 136 | 39 | 135 | 229 | 15 | 12 | 157 | 29 | 12 | 91 | 14 | 46 | 48 | 238 | 111 | 77 | 19 | 14 | 115 | 22 | 75 | 13 | 49 | 186 | 34 | 12191
RANKING | 0742 | 1520 | 1799 | 3716 | 4111 | 4121 | 4131 | 4214 | 4722 | 4816 | 5045 | 5065 | 5072 | 5074 | 5192 | 5211 | 5251 | 5261 | 5271 | 5411 | 5441 | 5499 | 5511 | 5521 | 5532 | 5533 | 5571 | 5599 | 5611 | 5621 | 5651 | 5655 | 5691 | 5699 | 5712 | 5713 | 5714 | 5719 | 5722 | 5732 | 5733 | 5812 | 5813 | 5814 | 5921 | 5932 | 5933 | 5940 | 5941 | 5942 | 5943 | 5944 | 5945 | 5946 | 5947 | 5948 | 5949 | 5964 | 5968 | 5970 | 5971 | 5977 | 5983 | 5992 | 5995 | 5999 | 6010 | 6012 | 6051 | 6211 | 6300 | 7011 | 7033 | 7230 | 7298 | 7299 | 7399 | 7512 | 7531 | 7538 | 7623 | 7629 | 7922 | 7933 | 7941 | 7991 | 7997 | 8021 | 8062 | 8071 | 8111 | 8220 | 8351 | 8675 | 8699 | 8911 | 8999 | 9399 | Grand Total
[NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 4 | 0 | 3
SARA CHAMBERS | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 1 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 5
SYBILLE MUIR | 4 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 4 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 3 | 1 | 0 | 3 | 0 | 4 | 3 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
ZOE MITCHELL | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 1 | 1 | 0 | 1 | 2 | 1 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 1 | 0 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 2 | 0 | 0 | 5 | 2 | 1 | 2 | 0 | 3 | 1 | 0 | 1 | 3 | 0 | 1 | 1 | 0 | 1 | 1 | 4 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 1 | 2 | 2 | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x