» 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:
- Business Plans For Dummies®
- The One Page Business Plan: Start With a Vision, Build a Company!
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Accounting for Dummies
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
