Spreadsheet: 494578d1482482457-mafia-game-vote-tally-vote-change-disregard-duplicate-values-and-summary-count-mafia-revised2
Sheet: Vote

 |  |  | Data Columns |  |  |  |  |  | Helper Columns |  |  |  |  |  |  |  |  | Last valid vote |  |  |  |  |  | Unique list of voters | Last valid vote |  |  | People who voted for Player in Column Y
 | # | Post | Ban? | Voter |  | Votee 1 | Votee 2 | Votee 3 | votes now invalid since voter muted |  |  | votes invalid because as changed vote later |  |  |  |  | Unique list of voters | Votee 1 | Votee 2 |  |  |  |  | Player | Votee 1 | Votee 2 | Votes | Here's what I want but couldn't figure out
 | 1 | 1 |  | Player 01 |  | Player 05 | Player 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 01
 | 2 | 2 |  | Player 03 |  | Player 27 | Player 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 02
 | 3 | 3 |  | Player 05 |  | Player 15 | Player 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 03
 | 4 | 4 |  | Player 07 |  | Player 38 | Player 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 04
 | 5 | 5 |  | Player 08 |  | Player 16 | Player 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 05
 | 6 | 6 |  | Player 21 |  | Player 22 | Player 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 06
 | 7 | 7 |  | Player 22 |  | Player 20 | Player 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 07
 | 8 | 8 |  | Player 17 |  | Player 03 | Player 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 08
 | 9 | 9 |  | Player 11 |  | Player 03 | Player 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 09
 | 10 | 10 |  | Player 05 |  | Player 09 | Player 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 10
 | 11 | 11 |  | Player 06 |  | Player 29 | Player 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 11
 | 12 | 12 |  | Player 05 |  | Player 07 | Player 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 12
 | 13 | 13 | 1 | Player 08 |  | Player 16 | Player 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 13
 | 14 | 14 |  | Player 14 |  | Player 20 | Player 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 14
 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 15
 | 16 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 16
 | 17 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 17
 | 18 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 18
 | 19 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 19
 | 20 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 20
 | 21 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 21
 | 22 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 22
 | 23 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 23
 | 24 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 24
 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 25
 | 26 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 26
 | 27 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 27
 | 28 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 28
 | 29 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 29
 | 30 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 30
 | 31 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 31
 | 32 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 32
 | 33 | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 33
 | 34 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 34
 | 35 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 35
 | 36 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 36
 | 37 | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 37
 | 38 | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 38
 | 39 | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 39
 | 40 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 40