Tip Printed from ExcelTip.com

---

Retrieving the Column Header of the Largest Value in a Row


Problem:

Range A1:E5 contains four players' scores in four games.
Each column from B to E contains the scores of one player for each of the four games listed in column A. The column header corresponds to the name of that particular player.
We want to add a new column (F) that contains the name of the winner of each game.
Solution:

Use the INDEX, MATCH, and MAX functions as shown in the following formula:
=INDEX($B$1:$E$1,1,MATCH(MAX(B2:E2),B2:E2,0))