Display Winner at bottom of spreadsheet

Amdivns

New Member
Joined
Sep 30, 2013
Messages
8
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?

Round 1Round 2Round 3Round 4Round 5TOTAL
Team 1N/AN/AN/A2,850N/A2,850
Team 2N/A7,5001,0500N/A8,550
Team 341,350N/AN/AN/AN/A41,350
Team 4N/AN/AN/AN/AN/A0
Team 59000009501,850
Team 63,0000N/AN/A03,000
Team 7N/AN/A4,350N/A1,5005,850
WINNERTEAM 3 - 41,350 Points

<colgroup><col><col span="5"><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Try this


Excel 2007
ABCDEFGH
1Round 1Round 2Round 3Round 4Round 5TOTAL
2Team 1N/AN/AN/A2,850N/A2,850
3Team 2N/A7,5001,0500N/A8,550
4Team 341,350N/AN/AN/AN/A41,350
5Team 4N/AN/AN/AN/AN/A0
6Team 59000009501,850
7Team 63,0000N/AN/A03,000
8Team 7N/AN/A4,350N/A1,5005,850
9
10WINNERTeam 3 with a Score of 41350 Points
Sheet1
Cell Formulas
RangeFormula
C10=INDEX(A2:A8,MATCH(MAX(G2:G8),G2:G8,0))&" with a Score of "&MAX(G2:G8)&" Points"
 
Upvote 0
Glad to hear...thanks for the feedback...(y)
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top