» Retrieving the Column Header of the Largest Value in a Row
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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))
Book Store:
Recommended Books:
No comments have been submitted.

