Collate all data - into a one list of unique names and totals

[slock92]

Hello,

PLEASE HELP!!

I run leagues across the country, and for each game the team plays a different teams, I record who scores what for each game... Is they way I cn collate all the data from the 10 games into 1 list per team? With only showing unique names and the points they got across all 10 games.

Ive attached sample data.

TIA :D :D

[JeteMc]

Perhaps this will be of some help although it isn't completely automated.
If you can get a complete roster of each team then you can skip to step 4.
1. Copy the longest list of players to column W.
2. Use conditional formatting to identify duplicates between the game with the longest list and each of the other lists. (In the attached file I used red formatting between the list from game 1 and the list from game 2. I then used yellow formatting between the list in game 1 and the list in game 3)
3. Add any unhighlighted players to the list in column W.
4. Populate column X using*: =SUMPRODUCT(IFERROR((A$81:E$92=W81)*(B$81:F$92),0))
5. Populate column V using: =AGGREGATE(14,6,X$81:X$95,ROWS(A$1:A1))
6. Populate column U using: =INDEX(W$81:W$95,AGGREGATE(15,6,(ROW(A$81:A$95)-ROW(A$80))/(X$81:X$95=V81),COUNTIFS(V$81:V81,V81)))
*Denotes an array entered formula which is confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Note that the ranges of the formulas will need to be changed for each team.
Note that columns W:X may be moved and/or hidden for aesthetic purposes.
Let us know if you have any questions.