Find the top 3 salespeople

[Jim_Robison]

Column A contains sales people and column B contains sales totals. I would like a formula, or VBA function, to display the name of the salesperson with the most (MAX) sales. I do not want to sort the sales data; don't ask why, it's a long story. Then I would like a formula to return the name of the salesperson with the second highest sales. Finally, I want the third highest sales, all without sorting tha data. I am currently using a nested "IF" function, but as the number of salespeople increases, my IF function is getting really ugly. Any ideas? Thanks.

[FDibbins]

deleted forum-induced duplicate thread?