Ok, So I have a Excel Sales tracker.
Vertically it has the name of the salesperson in the 1st column, and the dollar amount in sales in the second column.
At the bottom of the page, i want to have a sales leader displayed automatically.
What function will look at column 2, find the highest number, associate it with column 1 (their name) and display that name in the cell.
EXAMPLE
A1 A2
John 60
Mike 55
Kim 40
Dan 15
Kelly 85
Jim 50
Leaderboard (I want this to update automatically as the figures in A2 are changed) Kelly
Thanks !
I'm feeling a little clueless,
Mark
Bookmarks