Spreadsheet: 852867d1702862634-i-cannot-get-a-proper-count-to-work-2-neighbors-1-9
Sheet: Sheet4 (2)

 |  | SPINS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPINS
 |  | 1 | 2 | 3 | 1 | 2 | 3 |  | 1 | 2 | 3 |  |  |  |  |  | 1 | 2 | 3 | 1 | 2 | 3
 |  | 17 | 1 | 1 |  |  |  |  | 1 | 0 | 1 |  | 1 | 1 | First Instance |  | 17 | 1 | 1 | 2 | 1 | 2 |  | this is the proper count. 17 only shows up once in cell N36
 |  |  |  |  |  |  |  |  | 6 | 2 | 3 |  | 6 | 1 |  |  |  |  |  |  |  |  |  | Both columns [NAME] and [NAME] should have a count of two because the
 |  |  |  |  |  |  |  |  | 7 | 5 | 4 |  | 7 | 1 |  |  |  |  |  |  |  |  |  | First instance of a 1 is in O5 and in O46 because of the "1" entered in D5
 |  | 1 | 0 | 23 |  |  |  |  | 8 | 7 | 6 |  | 8 | 1 |  |  |  |  |  |  |  |  |  | The Second instance happens again when "1" is entered in E5 so now the counts
 |  |  |  |  |  |  |  |  | 9 | 9 | 9 |  | 9 | 1 |  |  |  |  |  |  |  |  |  | should go to "2" in U5 and W5
 |  |  |  |  |  |  |  |  | 10 | 10 | 10 |  | 10 | 1
 |  |  |  |  |  |  |  |  | 11 | 8 | 13 |  | 11 | 1
 |  |  |  |  |  |  |  |  | 13 | 12 | 14 |  | 13 | 1
 |  |  |  |  |  |  |  |  | 16 | 14 | 15 |  | 16 | 1
 |  |  |  |  |  |  |  |  | 18 | 15 | 16 |  | 18 | 1
 |  |  |  |  |  |  |  |  | 19 | 17 | 21 |  | 19 | 1
 |  |  |  |  |  |  |  |  | 20 | 19 | 23 |  | 20 | 1
 |  |  |  |  |  |  |  |  | 21 | 20 | 24 |  | 21 | 1
 |  |  |  |  |  |  |  |  | 26 | 22 | 33 |  | 26 | 1
 |  |  |  |  |  |  |  |  | 27 | 25 | 34 |  | 27 | 1
 |  |  |  |  |  |  |  |  | 30 | 28 | 35 |  | 30 | 1
 |  |  |  |  |  |  |  |  | 31 | 29 | 36 |  | 31 | 1
 |  |  |  |  |  |  |  |  | 32 | 32 | 37 |  | 32 | 1
 |  |  |  |  |  |  |  |  | 33 | 34 |  |  | 33 | 1
 |  |  |  |  |  |  |  |  | 36 | 35 |  |  | 36 | 1
 |  |  |  |  |  |  |  |  | 37 |  |  |  | 37 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | Second instance
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 3