Spreadsheet: 494573d1482479475-mafia-game-vote-tally-vote-change-disregard-duplicate-values-and-summary-count-mafia
Sheet: Vote

 |  |  | Data Columns |  |  |  |  |  | Helper Columns |  |  |  |  |  |  |  |  | Last valid vote
 | # | Post | Ban? | Voter |  | Votee 1 | Votee 2 | Votee 3 | Banned | Banned | Banned | Change | Change | Change |  |  | Unique list of voters | Votee 1 | Votee 2 |  |  |  |  | Player | Votes | Here's what I want but couldn't figure out
 | 1 | 1 |  | Player 1 |  | Player 5 | Player 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 1
 | 2 | 2 |  | Player 3 |  | Player 27 | Player 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 10
 | 3 | 3 |  | Player 5 |  | Player 15 | Player 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 11
 | 4 | 4 |  | Player 7 |  | Player 38 | Player 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 12
 | 5 | 5 |  | Player 8 |  | Player 16 | Player 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 13
 | 6 | 6 |  | Player 21 |  | Player 22 | Player 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 14
 | 7 | 7 |  | Player 22 |  | Player 20 | Player 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 15
 | 8 | 8 |  | Player 17 |  | Player 3 | Player 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 16 |  | Player 8 (5)
 | 9 | 9 |  | Player 11 |  | Player 3 | Player 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 17 |  | Player 7 (4)
 | 10 | 10 |  | Player 5 |  | Player 9 | Player 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 18
 | 11 | 11 |  | Player 6 |  | Player 29 | Player 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 19 |  | Player 21 (6) | Player 6 (11)
 | 12 | 12 |  | Player 5 |  | Player 7 | Player 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 2
 | 13 | 13 | 1 | Player 8 |  | Player 16 | Player 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 20
 | 14 | 14 |  | Player 14 |  | Player 20 | Player 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 21
 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 22
 | 16 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 23
 | 17 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 24
 | 18 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 25
 | 19 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 26
 | 20 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 27
 | 21 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 28
 | 22 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 29
 | 23 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 3
 | 24 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 30
 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 31
 | 26 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 32
 | 27 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 33
 | 28 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 34
 | 29 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 35
 | 30 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 36
 | 31 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 37
 | 32 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 38
 | 33 | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 39
 | 34 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 4
 | 35 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 40
 | 36 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 5
 | 37 | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 6
 | 38 | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 7
 | 39 | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 8
 | 40 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 9