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)