» Retrieving the Player Who Scored the Highest Number of Points
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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))
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The New Financial Order: Risk in the Twenty-First Century
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Excel VBA Programming for the Absolute Beginner
- PowerPoint® 2002 For Dummies®
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
