Spreadsheet: 66264d1266956249-create-a-list-from-a-column-and-eliminate-duplicates-list-jogier505-sdg10
Sheet: Sheet1

 |  |  |  |  |  |  |  | 50
Game |  |  |  |  |  |  | Winners by Game | Paid |  |  | Total by Name |  |  | The formula in cell L3, confirmed with CTRL + SHIFT + ENTER, and copied down.
Game 1 |  |  |  |  |  |  | [NAME] | 50 |  |  | E | 50 |  | '=IF(ROWS($L$3:[NAME])))
Game 2 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 50
Game 3 |  |  |  |  |  |  | E | 50 |  |  | [NAME] | 100 |  | [NAME]
Game 4 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 50
Game 5 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 550
Game 6 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 50
Game 7 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 50
Game 8 |  |  |  |  |  |  | [NAME] | 50 |  |  | [NAME] | 50
Game 9 |  |  |  |  |  |  | YOU | 50 |  |  | [NAME] | 50
Game 10 |  |  |  |  |  |  | [NAME] | 50 |  |  | YOU | 50
Game 11 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 50
Game 12 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 13 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 14 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 15 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 16 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 17 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 18 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 19 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 20 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 21 |  |  |  |  |  |  | [NAME] | 50 |  |  |  | 0
Game 22 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 23 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 24 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 25 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 26 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 27 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 28 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 29 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 30 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 31 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 32 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 33 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 34 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 35 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 36 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 37 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 38 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 39 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 40 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 41 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 42 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 43 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 44 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 45 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 46 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 47 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 48 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 49 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 50 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 51 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 52 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 53 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 54 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 55 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 56 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 57 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 58 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 59 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 60 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 61 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 62 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 63 |  |  |  |  |  |  |  |  |  |  |  | 0
Game 64 |  |  |  |  |  |  |  |  |  |  |  | 0