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?

[martindwilson]

why is ben second if he has the same score?
you might try unique ranking in a spare columm then match against that
enter in say O1
=RANK(N1,$N$1:$N$5)+COUNTIF($N$1:N1,N1)-1
and drag down this will rank them if 2 are the same the first one down the list gets ranked higher
then you can simply index match on 1,2,3,4,5,

[xp252]

why is ben second if he has the same score?
you might try unique ranking in a spare columm then match against that
enter in say O1
=RANK(N1,$N$1:$N$5)+COUNTIF($N$1:N1,N1)-1
and drag down this will rank them if 2 are the same the first one down the list gets ranked higher
then you can simply index match on 1,2,3,4,5,

Thank you! It works!