OK all you Excel experts, I apologize in advance as I know absolutely nothing about Excel formulas, except how to search for answers on this forum and try to do something similar
I am developing a report that is basically a sales leaderboard, and I have two issues:
1) I have a Top 5 count for the entire company, and it works OK, unless two or more people are tied (this happens quite often....). Here is the formula I used:
=INDEX($B$3:$B$30,MATCH(LARGE($C$3:$C$30,E4),$C$3:$C$30,0),1)
Context:
Column B: Salesperson Name (which is what I want to return)
Column C: Units Sold
(skipped column D for formatting)
Column E: Use it for the ranking (E4 is 1, E5 is 2, etc.)
How can I show any ties and list all the names of those people?
2) I would like to create a single cell that shows the top rep by region, and the corresponding region is in Column A. I only need the Top 1 person (B) who is within the region (A) and has the highest results (C). Tried multiple searches on the site by adding an IF function, etc. and I frankly have no clue what I'm doing.
Any help is greatly appreciated! Thank you so much!
Bookmarks