=INDEX(B1:B20,SUMPRODUCT(--(C1:C20=MAX(IF(A1:A20=A2,C1:C20))),ROW(A1:A20)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Renee" wrote in message
...
Good afternoon all,

I have 3 columns: Teacher Trainee Score

The teachers' names will repeat as each teacher will have multiple
trainees.
I used advance filter to copy unique values of Teacher Names to a new
location in the workbook.

Next to each Teachers' name I would like to display the Trainee's name
with
the maximum score among that Teacher's trainees.

Example
A B C
1 Teacher Trainee Score
2 Bob Sarah 100
3 Bob James 95
4 Michelle Harold 97
5 Michelle Lori 93

Teachers' Top performers!
8 Bob Sara
9 Michelle Harold

I have been experimenting with:
B8 would be =If(AND(C2:C5 = Max(C2:C5), A8 = A1:A5),B1:B5)

I would appreciate any guidance here!
Renee