Display Winner at bottom of spreadsheet

[Amdivns]

Hi,

I'm a tad rusty with my Excel Skills, I'm trying to get the attached spreadsheet to automatically update the "WINNER" section with the following fields "TEAM NAME- POINT SCORE"

eg WINNER - "TEAM 3 - 41,350 POINTS" based on who has the highest points.

Essentially, what I think I need to do is link the team name to the total points field, and then make excel populate the bottom of the scoreboard with the data...Can anyone help?

[TABLE="width: 565"]
<colgroup><col><col span="5"><col><col></colgroup><tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Round 1[/TD]
[TD]Round 2[/TD]
[TD]Round 3[/TD]
[TD]Round 4[/TD]
[TD]Round 5[/TD]
[TD]TOTAL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 1[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]2,850[/TD]
[TD]N/A[/TD]
[TD]2,850[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 2[/TD]
[TD]N/A[/TD]
[TD]7,500[/TD]
[TD]1,050[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]8,550[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 3[/TD]
[TD]41,350[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]41,350[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 4[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 5[/TD]
[TD]900[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]950[/TD]
[TD]1,850[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 6[/TD]
[TD]3,000[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]3,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team 7[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]4,350[/TD]
[TD]N/A[/TD]
[TD]1,500[/TD]
[TD]5,850[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WINNER[/TD]
[TD][/TD]
[TD="colspan: 6"]TEAM 3 - 41,350 Points[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Try this

Excel 2007
	A	B	C	D	E	F	G	H
1		Round 1	Round 2	Round 3	Round 4	Round 5	TOTAL
2	Team 1	N/A	N/A	N/A	2,850	N/A	2,850
3	Team 2	N/A	7,500	1,050	0	N/A	8,550
4	Team 3	41,350	N/A	N/A	N/A	N/A	41,350
5	Team 4	N/A	N/A	N/A	N/A	N/A	0
6	Team 5	900	0	0	0	950	1,850
7	Team 6	3,000	0	N/A	N/A	0	3,000
8	Team 7	N/A	N/A	4,350	N/A	1,500	5,850
9
10	WINNER		Team 3 with a Score of 41350 Points
Sheet1

Cell Formulas
Range	Formula
C10	=INDEX(A2:A8,MATCH(MAX(G2:G8),G2:G8,0))&" with a Score of "&MAX(G2:G8)&" Points"

 

[Amdivns]

Thanks! That worked brilliantly!

 

[Michael M]

Glad to hear...thanks for the feedback...