Ranking Sales Reps

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

Im able to rank my sales reps in a column but i would like to take the top
sales rep in that column display his name in a different cell. Here is my
ranking formula which ranks the sales reps by numbers. I would like to take
the top sales rep based off the number ranking and display his name in a
different cell. How can this be done?

Rank formula: =RANK($H15,$H$6:$H$25,0)
 
Hi,

lets say we have reps in column A and their sales performance in column B.
Try this

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

or if we have their rank in column B try

=INDEX(A1:A10,MATCH(MIN(B1:B10),B1:B10,0))

Mike
 
You can do a rank-order with a compound function such as this:
=INDEX($A$1:$A$11,RANK(B1,$B$1:$B$11))

HTH,
Ryan---
 
Back
Top