» 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:
- Accounting the Easy Way
- Adventure Capitalist: The Ultimate Road Trip
- Microsoft Windows XP Step by Step (With CD-ROM)
- Investing in Real Estate, Fourth Edition
- How to Pay Zero Taxes (Annual)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
