Team with highest number of wins
This example shows how to calculate the team with the highest number of wins
Example: Team with highest number of wins
|
This formula can be used to calculate the team with the highest number of wins. This examples assumes there are four teams (Team A, B, C and D) that have all played against each other with Team D winning all of the three matches, which is more than any other team in the group. The winning team is listed in range (D5:D10).
|
EXPLANATION
This example shows how to calculate the team with the highest number of wins. It uses a combination of Excel INDEX, MODE and MATCH functions to calculate the student with the highest mark.
This example shows how to calculate the team with the highest number of wins. It uses a combination of Excel INDEX, MODE and MATCH functions to calculate the student with the highest mark.
If the list of teams is greater or lower then number of teams that are used in this example you can insert or remove the teams that have played against each other and the winning team in columns B, C and D and change the associated ranges in the formula.
FORMULA
=INDEX(winners_rng,MODE(MATCH(winners_rng),marks_rng,0)))
=INDEX(winners_rng,MODE(MATCH(winners_rng),marks_rng,0)))
ARGUMENTS
winners_rng: List of the winning teams.
winners_rng: List of the winning teams.
APPLICATION
The calculation to identify the team with the highest number of wins from a pool of other teams that is shown in this example can be applied to team sports. Examples of such sports are, but not limited to, soccer, football and basketball.
The calculation to identify the team with the highest number of wins from a pool of other teams that is shown in this example can be applied to team sports. Examples of such sports are, but not limited to, soccer, football and basketball.