» 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:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Business Plans For Dummies®
- Special Edition Using Microsoft Outlook 2002
- Guide to Financial Reporting and Analysis
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.
