Getting the name of the top 3 marks

[Statue]

Hi,
I have a data like this

Smith 12
John 15
Kate 14
Ivan 17

I used the formula "=LARGE(A1:A4,1)" formula to get the highest mark.
But now what i really want is to get the name of the student who scored the highest mark in a separate cell.
I you guys could help me it would be great.
Thanks in advance.

[Fotis1991]

Hi. Welcome to the forum.

=INDEX(B1:B4,MATCH(C1,A1:A4,0))

A= NUMBERS
B= NAMES

c1=Your Large, function.

Is this, works for you?

[Statue]

Thank you very much for your help.
I worked just fine.
It's been a great help,
Thanks again

[Fotis1991]

You are welcome.

Would you pls, mark your thread, as Solved(Look at the top of the page)?

[Statue]

Hi,
I've got another problem when i enter the formula you gave me works just fine but when two students comes in same place the name is not working correctly,

Example:
1 Smith 15
2 John 15
3 Kate 14

The name cell is coming the same name even Smith and John are equal.

[Fotis1991]

..So, in this case, pls, take a look here. You'll find your solution.

http://www.excelforum.com/excel-work...om-a-list.html

[Statue]

Perfect,
It helped me a lot,
Thank you very much...