Ranking Sales Reps
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) |
Ranking Sales Reps
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 "Frustrated" wrote: 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) |
Ranking Sales Reps
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Frustrated" wrote: 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) |
All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com