Tip Printed from ExcelTip.com

---

Retrieving the Player Who Scored the Highest Number of Points


Problem:

Column B contains the number of points scored by each player listed in column A.
We want to retrieve the name of the player who scored the highest number of points.

Solution:

Use the INDEX, MATCH, and MAX functions in the following formula:
=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))