Lowest scoring player
This example shows how to calculate the lowest scoring player from a list of players
Example: Lowest scoring player
|
This formula can be used to calculate the lowest scoring player from a list of players. This example assumes there are 11 players, who are listed in range (B5:B15) with the number of goals scored by each player recorded in the column to the right in range (C5:C15).
|
EXPLANATION
This example shows how to calculate the lowest scoring player from a list of players. It uses a combination of Excel INDEX, MATCH and MIN functions to calculate the lowest scoring player.
This example shows how to calculate the lowest scoring player from a list of players. It uses a combination of Excel INDEX, MATCH and MIN functions to calculate the lowest scoring player.
FORMULA
=INDEX(players_rng,MATCH(MIN(goals_rng),goals_rng,0))
=INDEX(players_rng,MATCH(MIN(goals_rng),goals_rng,0))
ARGUMENTS
players_rng: List of players.
goals_rng: The number of goals scored by a player in the players range.
players_rng: List of players.
goals_rng: The number of goals scored by a player in the players range.
APPLICATION
The calculation of the lowest scoring player that is shown in this example can be applied to multiple sports that have more than one player and where the players score goals. Examples of such sports are, but not limited to, soccer, football and basketball.
The calculation of the lowest scoring player that is shown in this example can be applied to multiple sports that have more than one player and where the players score goals. Examples of such sports are, but not limited to, soccer, football and basketball.