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?
<colgroup><col><col span="5"><col><col></colgroup><tbody>
</tbody>
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 1 | Round 2 | Round 3 | Round 4 | Round 5 | TOTAL | ||
Team 1 | N/A | N/A | N/A | 2,850 | N/A | 2,850 | |
Team 2 | N/A | 7,500 | 1,050 | 0 | N/A | 8,550 | |
Team 3 | 41,350 | N/A | N/A | N/A | N/A | 41,350 | |
Team 4 | N/A | N/A | N/A | N/A | N/A | 0 | |
Team 5 | 900 | 0 | 0 | 0 | 950 | 1,850 | |
Team 6 | 3,000 | 0 | N/A | N/A | 0 | 3,000 | |
Team 7 | N/A | N/A | 4,350 | N/A | 1,500 | 5,850 | |
WINNER | TEAM 3 - 41,350 Points | ||||||
<colgroup><col><col span="5"><col><col></colgroup><tbody>
</tbody>