Issue with table!

[Fry1807]

Guys,

First time poster here, I've been using Excel for a while but I'm pretty near to n00b status.

Anywho, I have a table consisting of 20-22 or so rows, with 3 columns.

Left column = name of student
Middle column=student number
right column = overall average

I also have a seperate cell on the same sheet indicating the highest overall average.

My goal is to also below that speperate cell to list the name of the student with the highest average.

So I need to search the max value in column 3 and then then match the same row from column 1 and display in this seperate cell. How would I do this?

I guess I could reference the highest overall average which is already calculated to make the formula more simple...

Help would be appreciated more than you know!

Fry

[Cheeky Charlie]

Find the high score:
=max(<scores column>)

Find out where it comes in the column:
=match(max(<scores column>),<scores column>,0)

Return the name from the same row:
=index(<names column>,match(max(<scores column>),<scores column>,0))

HTH