can this be fixed to find for next name

[fivermsg]

I am using this formula to automatically "display" a name from a list of
total points to make a rank that will consistantly change as the points
change.. I only want to display the top six names..Right now this
formula will do that but when there is a tie it displays the same name
twice and will skip the next name in the order.. any suggestions??

INDEX(A2:A13,MATCH(LARGE(B2:B13,1),B2:B13,0))

 

[Peo Sjoblom]

Use rank instead

Chip has examples here

http://www.cpearson.com/excel/rank.htm