Tip Printed from ExcelTip.com

---

Finding the Score that Was the Nth Highest for a Specified Team


Problem:

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.

Solution:

Use the LARGE function in the following Array formula:
{=LARGE(($B$2:$B$6=E2)*($C$2:$C$6),2)}