Spreadsheet: 847769d1698648579-counting-two-numbers-in-the-same-cell-corner-and-quads-alternate
Sheet: CORNERS & QUADS MASTER (7)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | C1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1 | C1 |  | C2 | C2 |  | [NAME] | [NAME] |  | C4 | C4 |  |  | 4 | 13 | C1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 22 | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUADS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUADS |  |  |  |  | QUADS SEQUENCE |  |  |  |  | CORNERS |  |  |  |  | [NAME] |  |  |  |  | 7 | 7 |  | 1 | 1 |  | 3 | 3 |  | 9 | 9 |  |  | 4 | 31 | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4
 | QUADS |  |  | CORNERS |  |  | UNIVERSAL |  |  |  |  |  |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 4 | 8 |  | 2 | 4 |  | 2 | 6 |  | 6 | 8 |  |  | 7 | 7 | C1 |  | 15 = 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORNERS | 1 | 5 | 8 | 14 | 17 | 23 | 26 | 32 | 35
 | 4 | 1 |  | 4 | 1 |  | 1 | 1 |  | QUAD 1 | 1 - 9 |  | 1 | 15 | 30 | 8 | 11 | 1 | 1 | 2 | 3 | 4 | 1 |  |  |  |  | 1 | 1 | 2 | 3 | 4 | 1 |  |  |  |  |  |  | 1 |  | 2 |  |  | 2 | 2 |  |  | 1 |  |  | 7 | 16 | C1 |  | 30 = 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 7 | 13 | 16 | 22 | 25 | 31 | 34
 | 5 | 1 |  | 5 | 1 |  | 4 | 1 |  | QUAD 2 | 10 - 18 |  | 2 | 3 | 1 | 33 | 23 | 2 | 1 | 2 | 3 | 4 | 2 |  |  |  |  | 2 | 1 | 2 | 3 | 4 | 2 |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 2 |  | 1 |  |  |  | 7 | 25 | C1 |  | 11 = 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 5 | 11 | 14 | 20 | 23 | 29 | 32
 | 7 | 1 |  | 7 | 1 |  | 7 | 1 |  | QUAD 3 | 19 - 27 |  | 3 | 16 | 30 | 5 | 36 | 3 | 1 | 2 | 3 | 4 | 3 |  |  |  |  | 3 | 1 | 2 | 3 | 4 | 3 |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  | 7 | 34 | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4 | 10 | 13 | 19 | 22 | 29 | 31
 | 8 | 1 |  | 8 | 1 |  | 12 | 1 |  | QUAD 4 | 28 - 36 |  | 4 | 3 | 27 | 26 | 15 | 4 | 1 | 2 | 3 | 4 | 4 |  |  |  |  | 4 | 1 | 2 | 3 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 2 | 2 |  |  | 8 | 8 | C1 |  | The first number is 15, which for my purposes = 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 6 | 12 | 15 | 21 | 24 | 30 | 33
 | 1 | 1 |  | 13 | 1 |  | 15 | 1 |  |  |  |  | 5 | 18 | 30 | 22 | 21 | 5 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 5 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 |  |  |  | 1 |  | 2 | 2 |  | 1 | 1 |  |  | 8 | 17 | C1 |  | I need 6 to be recorded in cell [NAME] and cell AW8. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 11 | 14 | 20 | 23 | 29 | 32
 | 2 | 1 |  | 14 | 1 |  | 19 | 1 |  | CORNER 1 | 4 5 7 8 |  | 6 |  |  |  |  | 6 | 1 | 2 | 3 | 4 | 6 |  |  |  |  | 6 | 1 | 2 | 3 | 4 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 26 | C1 |  | 30 for my purposes = 3. that needs to get recorded in cells AT8 and AU8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 6 | 9 | 15 | 18 | 24 | 27 | 33 | 36
 | 4 | 1 |  | 16 | 1 |  | 19 | 1 |  | CORNER 2 | 1 2 4 5 |  | 7 |  |  |  |  | 7 | 1 | 2 | 3 | 4 | 7 |  |  |  |  | 7 | 1 | 2 | 3 | 4 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 35 | C1 |  | Because AU8 already had 1 from #15 the total in AU8 should go to 2 now |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 8 | 14 | 17 | 23 | 26 | 32 | 35
 | 5 | 1 |  | 17 | 1 |  | 22 | 1 |  | CORNER 3 | 2 3 5 6 |  | 8 |  |  |  |  | 8 | 1 | 2 | 3 | 4 | 8 |  |  |  |  | 8 | 1 | 2 | 3 | 4 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | C2 |  | That is the same pattern all the way down the C1, C2, C3 & C4 columns
 | 2 | 1 |  | 22 | 1 |  | 25 | 1 |  | CORNER 4 | 5 6 8 9 |  | 9 |  |  |  |  | 9 | 1 | 2 | 3 | 4 | 9 |  |  |  |  | 9 | 1 | 2 | 3 | 4 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10 | C2
 | 3 | 1 |  | 23 | 1 |  | 2 | 2 |  |  |  |  | 10 |  |  |  |  | 10 | 1 | 2 | 3 | 4 | 10 |  |  |  |  | 10 | 1 | 2 | 3 | 4 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 19 | C2
 | 5 | 1 |  | 25 | 1 |  | 5 | 2 |  |  |  |  | 11 |  |  |  |  | 11 | 1 | 2 | 3 | 4 | 11 |  |  |  |  | 11 | 1 | 2 | 3 | 4 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 28 | C2
 | 6 | 1 |  | 26 | 1 |  | 8 | 2 |  |  |  |  | 12 |  |  |  |  | 12 | 1 | 2 | 3 | 4 | 12 |  |  |  |  | 12 | 1 | 2 | 3 | 4 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | C2
 | 5 | 1 |  | 31 | 1 |  | 10 | 2 |  |  |  |  | 13 |  |  |  |  | 13 | 1 | 2 | 3 | 4 | 13 |  |  |  |  | 13 | 1 | 2 | 3 | 4 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 11 | C2
 | 6 | 1 |  | 32 | 1 |  | 13 | 2 |  |  |  |  | 14 |  |  |  |  | 14 | 1 | 2 | 3 | 4 | 14 |  |  |  |  | 14 | 1 | 2 | 3 | 4 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 20 | C2
 | 8 | 1 |  | 34 | 1 |  | 16 | 2 |  |  |  |  | 15 |  |  |  |  | 15 | 1 | 2 | 3 | 4 | 15 |  |  |  |  | 15 | 1 | 2 | 3 | 4 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 29 | C2 |  |  | 24
 | 9 | 1 |  | 35 | 1 |  | 30 | 2 |  |  |  |  | 16 |  |  |  |  | 16 | 1 | 2 | 3 | 4 | 16 |  |  |  |  | 16 | 1 | 2 | 3 | 4 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | C2
 | 13 | 2 |  | 1 | 2 |  | 33 | 2 |  |  |  |  | 17 |  |  |  |  | 17 | 1 | 2 | 3 | 4 | 17 |  |  |  |  | 17 | 1 | 2 | 3 | 4 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 13 | C2
 | 14 | 2 |  | 2 | 2 |  | 36 | 2 |  |  |  |  | 18 |  |  |  |  | 18 | 1 | 2 | 3 | 4 | 18 |  |  |  |  | 18 | 1 | 2 | 3 | 4 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 22 | C2
 | 16 | 2 |  | 4 | 2 |  | 3 | 3 |  |  |  |  | 19 |  |  |  |  | 19 | 1 | 2 | 3 | 4 | 19 |  |  |  |  | 19 | 1 | 2 | 3 | 4 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 31 | C2
 | 17 | 2 |  | 5 | 2 |  | 6 | 3 |  |  |  |  | 20 |  |  |  |  | 20 | 1 | 2 | 3 | 4 | 20 |  |  |  |  | 20 | 1 | 2 | 3 | 4 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | [NAME]
 | 10 | 2 |  | 10 | 2 |  | 9 | 3 |  |  |  |  | 21 |  |  |  |  | 21 | 1 | 2 | 3 | 4 | 21 |  |  |  |  | 21 | 1 | 2 | 3 | 4 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 12 | [NAME]
 | 11 | 2 |  | 11 | 2 |  | 20 | 3 |  |  |  |  | 22 |  |  |  |  | 22 | 1 | 2 | 3 | 4 | 22 |  |  |  |  | 22 | 1 | 2 | 3 | 4 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 21 | [NAME]
 | 13 | 2 |  | 13 | 2 |  | 23 | 3 |  |  |  |  | 23 |  |  |  |  | 23 | 1 | 2 | 3 | 4 | 23 |  |  |  |  | 23 | 1 | 2 | 3 | 4 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 30 | [NAME]
 | 14 | 2 |  | 14 | 2 |  | 26 | 3 |  |  |  |  | 24 |  |  |  |  | 24 | 1 | 2 | 3 | 4 | 24 |  |  |  |  | 24 | 1 | 2 | 3 | 4 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | [NAME]
 | 11 | 2 |  | 19 | 2 |  | 28 | 3 |  |  |  |  | 25 |  |  |  |  | 25 | 1 | 2 | 3 | 4 | 25 |  |  |  |  | 25 | 1 | 2 | 3 | 4 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 11 | [NAME]
 | 12 | 2 |  | 20 | 2 |  | 31 | 3 |  |  |  |  | 26 |  |  |  |  | 26 | 1 | 2 | 3 | 4 | 26 |  |  |  |  | 26 | 1 | 2 | 3 | 4 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 20 | [NAME]
 | 14 | 2 |  | 22 | 2 |  | 34 | 3 |  |  |  |  | 27 |  |  |  |  | 27 | 1 | 2 | 3 | 4 | 27 |  |  |  |  | 27 | 1 | 2 | 3 | 4 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 29 | [NAME]
 | 15 | 2 |  | 23 | 2 |  | 11 | 4 |  |  |  |  | 28 |  |  |  |  | 28 | 1 | 2 | 3 | 4 | 28 |  |  |  |  | 28 | 1 | 2 | 3 | 4 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | [NAME]
 | 14 | 2 |  | 28 | 2 |  | 14 | 4 |  |  |  |  | 29 |  |  |  |  | 29 | 1 | 2 | 3 | 4 | 29 |  |  |  |  | 29 | 1 | 2 | 3 | 4 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 15 | [NAME]
 | 15 | 2 |  | 29 | 2 |  | 17 | 4 |  |  |  |  | 30 |  |  |  |  | 30 | 1 | 2 | 3 | 4 | 30 |  |  |  |  | 30 | 1 | 2 | 3 | 4 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 24 | [NAME]
 | 17 | 2 |  | 31 | 2 |  | 21 | 4 |  |  |  |  | 31 |  |  |  |  | 31 | 1 | 2 | 3 | 4 | 31 |  |  |  |  | 31 | 1 | 2 | 3 | 4 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 33 | [NAME]
 | 18 | 2 |  | 32 | 2 |  | 24 | 4 |  |  |  |  | 32 |  |  |  |  | 32 | 1 | 2 | 3 | 4 | 32 |  |  |  |  | 32 | 1 | 2 | 3 | 4 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 9 | C4
 | 22 | 3 |  | 2 | 3 |  | 27 | 4 |  |  |  |  | 33 |  |  |  |  | 33 | 1 | 2 | 3 | 4 | 33 |  |  |  |  | 33 | 1 | 2 | 3 | 4 | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 18 | C4
 | 23 | 3 |  | 3 | 3 |  | 29 | 4 |  |  |  |  | 34 |  |  |  |  | 34 | 1 | 2 | 3 | 4 | 34 |  |  |  |  | 34 | 1 | 2 | 3 | 4 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 27 | C4
 | 25 | 3 |  | 5 | 3 |  | 32 | 4 |  |  |  |  | 35 |  |  |  |  | 35 | 1 | 2 | 3 | 4 | 35 |  |  |  |  | 35 | 1 | 2 | 3 | 4 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 36 | C4
 | 26 | 3 |  | 6 | 3 |  | 35 | 4 |  |  |  |  | 36 |  |  |  |  | 36 | 1 | 2 | 3 | 4 | 36 |  |  |  |  | 36 | 1 | 2 | 3 | 4 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | C4
 | 19 | 3 |  | 11 | 3 |  |  |  |  |  |  |  | 37 |  |  |  |  | 37 | 1 | 2 | 3 | 4 | 37 |  |  |  |  | 37 | 1 | 2 | 3 | 4 | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 15 | C4
 | 20 | 3 |  | 12 | 3 |  |  |  |  |  |  |  | 38 |  |  |  |  | 38 | 1 | 2 | 3 | 4 | 38 |  |  |  |  | 38 | 1 | 2 | 3 | 4 | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 24 | C4
 | 22 | 3 |  | 14 | 3 |  |  |  |  |  |  |  | 39 |  |  |  |  | 39 | 1 | 2 | 3 | 4 | 39 |  |  |  |  | 39 | 1 | 2 | 3 | 4 | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 33 | C4
 | 23 | 3 |  | 15 | 3 |  |  |  |  |  |  |  | 40 |  |  |  |  | 40 | 1 | 2 | 3 | 4 | 40 |  |  |  |  | 40 | 1 | 2 | 3 | 4 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | C4
 | 20 | 3 |  | 20 | 3 |  |  |  |  |  |  |  | 41 |  |  |  |  | 41 | 1 | 2 | 3 | 4 | 41 |  |  |  |  | 41 | 1 | 2 | 3 | 4 | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 17 | C4
 | 21 | 3 |  | 21 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 26 | C4
 | 23 | 3 |  | 23 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 35 | C4
 | 24 | 3 |  | 24 | 3
 | 23 | 3 |  | 29 | 3
 | 24 | 3 |  | 30 | 3
 | 26 | 3 |  | 32 | 3
 | 27 | 3 |  | 33 | 3
 | 31 | 4 |  | 5 | 4
 | 32 | 4 |  | 6 | 4
 | 34 | 4 |  | 8 | 4
 | 35 | 4 |  | 9 | 4
 | 28 | 4 |  | 14 | 4
 | 29 | 4 |  | 15 | 4
 | 31 | 4 |  | 17 | 4
 | 32 | 4 |  | 18 | 4
 | 29 | 4 |  | 23 | 4
 | 30 | 4 |  | 24 | 4
 | 32 | 4 |  | 26 | 4
 | 33 | 4 |  | 27 | 4
 | 32 | 4 |  | 32 | 4
 | 33 | 4 |  | 33 | 4
 | 35 | 4 |  | 35 | 4
 | 36 | 4 |  | 36 | 4