Finding the largest value and naming the cell

[AceAidan]

I've made a few sheets in excel, naming them Team 1, Team 2, so on. On each sheet, I put a table of how many goals the score in a game and there's a total sum up. Then in a new sheet, I made another table and used (=MAX(Team 1:Team11!H8)) and (=LARGE(Team 1:Team11!H8,2)) and (=LARGE(Team 1:Team11!H8,3)) to find the first, second and third place. Now I want to add their team name into the cell next to it as well. So like Team 1 got 12, and Team 2 for 10, I want it to show cell A2 First Place, B2 amount of points so 12 and C2 the team name, which in this case is Team1. How can I do it?
Teams.xlsx

[Glenn Kennedy]

1. Your totals in H8 are incorrect. You've added the values TWICE. I haven't changed it, but you should use =SUM(B2:G7)

2. In your older Excel procduct, this will be an array formula (needing CTRL-SHIFT-ENTER and not just ENTER). You'll know it's OK if Excel (not you) inserts a set of {} roud trhe formula.


=LARGE('Team 1:Team 3'!$H$8,ROWS(B$2:B2))&" Points "&INDEX($J$1:$J$3,MATCH(1,COUNTIF(INDIRECT("'"&$J$1:$J$3&"'!H8"),LARGE('Team 1:Team 3'!$H$8,ROWS(B$2:B2))),0))

copied DOWN.

3. Are tied scores possible? If so, HOW do you want ties to be reported?