I have an spreadsheet that has different sales reps in column A.
In column B is the District the sales rep resides in. There could be many
sales reps per District.
In column C are the number of sales the sales rep had.
Is there a way to get PER DISTRICT the top 5 employees according to their
number of sales?
For example, in
District1 John Doe $2M
District1 Jack Doe $1.5M
District1 Suzy Doe $1M
etc.
District2 Michael Doe $5M
District2 Michelle Doe $4.5M
etc.
Thanks so much.
Bookmarks