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