» Ranking Salespeople According to Sales Figure
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Range A1:B6 contains salespeople's names and their total number of sales.
We want to rank the top 3 salespeople according to their sales performance.
Solution:
Use the INDEX, MATCH, and LARGE functions as shown in the following formula:
=INDEX($A$2:$A$6,MATCH(LARGE($B$2:$B$6,A9),$B$2:$B$6,0))
Book Store:
Recommended Books:
- Now, Discover Your Strengths
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Investing in Real Estate, Fourth Edition
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.
