Tip Printed from ExcelTip.com

---

Ranking Salespeople According To Sales Figure


Problem:

Range A1:B6 contains salesperson'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))

Example:

Range1

Name______Total
Mike______500
Donna_____1000
David_____700
Mischelle_300
John______1200

Range2

Rank____Name
1_______John
2_______Donna
3_______David