| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering the top 5 transactions from a list of 10 reps | Excel Discussion (Misc queries) | |||
| Filtering totals - Reps per Province | Excel Worksheet Functions | |||
| sales reps pricing | Excel Worksheet Functions | |||
| How do you set up the data to perform a Anova 2 Factor/w reps? | Excel Worksheet Functions | |||
Threaded Mode
