| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Top 5 in group and bottom 5 in group
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) | |||
| How do I see the sum or other function in the bottom bar of my Ex. | Excel Worksheet Functions | |||
Threaded Mode
