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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,549
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Try this

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Round 1</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Round 2</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Round 3</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Round 4</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Round 5</td><td style="font-weight: bold;text-decoration: underline;color: #008000;background-color: #FAFAFA;;">TOTAL</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 1</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">2,850</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">2,850</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 2</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">7,500</td><td style="color: #333333;background-color: #FAFAFA;;">1,050</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">8,550</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 3</td><td style="color: #333333;background-color: #FAFAFA;;">41,350</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">41,350</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 4</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 5</td><td style="color: #333333;background-color: #FAFAFA;;">900</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="color: #333333;background-color: #FAFAFA;;">950</td><td style="color: #333333;background-color: #FAFAFA;;">1,850</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 6</td><td style="color: #333333;background-color: #FAFAFA;;">3,000</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">0</td><td style="color: #333333;background-color: #FAFAFA;;">3,000</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-decoration: underline;color: #333333;background-color: #FAFAFA;;">Team 7</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">4,350</td><td style="font-weight: bold;color: #696969;background-color: #FAFAFA;;">N/A</td><td style="color: #333333;background-color: #FAFAFA;;">1,500</td><td style="color: #333333;background-color: #FAFAFA;;">5,850</td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;color: #333333;background-color: #FAFAFA;;">WINNER</td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;">Team 3 with a Score of 41350 Points</td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td><td style="color: #333333;background-color: #FAFAFA;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C10</th><td style="text-align:left">=INDEX(<font color="Blue">A2:A8,MATCH(<font color="Red">MAX(<font color="Green">G2:G8</font>),G2:G8,0</font>)</font>)&" with a Score of "&MAX(<font color="Blue">G2:G8</font>)&" Points"</td></tr></tbody></table></td></tr></table><br />
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,549
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Glad to hear...thanks for the feedback...(y)
 

Forum statistics

Threads
1,136,775
Messages
5,677,656
Members
419,708
Latest member
PhilD

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
Top