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]

Take a look at using =LARGE() for the sales, then index/match for the name

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Jim_Robison]

LARGE worked, along with INDEX and MATCH. This was my first post on this forum. I am very impressed and will return frequently.

Thanks,
Jim

[FDibbins]

I am happy we were able to help you, look forward to seeing more or you soon