Data Ranking not Working!

[xp252]

Hi there, long time reader, first time poster.

I am having trouble getting this equation to work correctly:

"=INDEX(B:B,MATCH(MAX(LARGE(N:N,1)),N:N,0))".

I have names in Column B and scores in Column N. The equation does correctly displays the highest score of Column N. However, it does not work correctly if two of the scores are the same.

Column B Column N
John 89
Jacob 91
Max 82
Ben 91
Sam 85

First Place: Jacob
Second Place: Jacob (this should be Ben if Jacob is first place)
Third Place: John

Does anyone know what I'm doing wrong?

 

[crimson_b1ade]

check out this Mr.Excel podcast which you might find interesting: http://www.mrexcel.com/Excel_Kissing_Your_Sister_training.html

 

[xp252]

check out this Mr.Excel podcast which you might find interesting: http://www.mrexcel.com/Excel_Kissing_Your_Sister_training.html

Thank you! It works!