» Ranking Salespeople According to Sales Figure
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: 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:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Microsoft Access Version 2002 Step by Step
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Windows XP Inside Out
- The Basics of Finance: Financial Tools for Non Financial Managers
- Special Edition Using Microsoft Outlook 2002
No comments have been submitted.
