» Finding the Score that Was the Nth Highest for a Specified Team
Range A2:C6 shows the respective teams and scores for a group of players.
We want to create a formula that will retrieve the second highest score from column C that matches each team listed in column E.
Use the LARGE function in the following Array formula:
|Screenshot // Finding the Score that Was the Nth Highest for a Specified Team |