Large function with cells that have the same value

[Palmetto274]

I have a function =INDEX($A$2:$A$708,(MATCH(LARGE(($N$2:$N$708),2),(($N$2:$N$708)),0))) which works great to return a name for the nth value in Column N, but I've run into a problem. When column N has two of the same value (50 for example) then I receive only the first name, but twice. I feel confident adding a Count If somewhere in the function will resolve this issue, but I'm not sure where the Count If goes... Any help is greatly appreciated.

thanks!

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Show us where to look and where you need the fix.

[Palmetto274]

Here you go!Thanks!

Help Please.xlsx

[NBVC]

First extract the scores, say in E2:

=LARGE($B$2:$B$9,ROWS($D$2:$D2))

copied down

Then in D2:

=INDEX(A$2:A$9,SMALL(IF($B$2:$B$9=E2,ROW($A$2:$A$9)-ROW($A$2)+1),COUNTIF($E$2:$E2,$E2)))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down.