This gets the name of the top person

=INDEX(B1:B100,MATCH(LARGE(IF(A1:A100="District1", C1:C100),ROW(A1)),C1:C100,
0))

as an array formula, so commit with Ctrl-SHift-Enter.

Drag down 4 rows to get 2,3,4,5. To get the amount, replace the first
B1:B100 by C1:C100

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jhicsupt" wrote in message
...
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.