I'm trying to ask a complicated question in a simple way. If you had the following table, how would you retrieve the salesman with the highest revenue? Note that I want the Revenue value AND the Salesman's name. Obviously, I could create a Pivot table with a max value on Revenue, but how to get the associated salesman as well?

Division Salesman Revenue
A Jones 100
A Smith 50
A Davis 250
A Samuels 600
A Shaugnessy 350
A Wildstein 425
B Feldman 50
B Bailey 275
B Potts 300
B Dawkins 400
B Measley 125