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



--

Regards,

Peo Sjoblom


"fivermsg" <[email protected]> wrote in
message news:[email protected]...
>
> 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))
>
>
> --
> fivermsg
> ------------------------------------------------------------------------
> fivermsg's Profile:
> http://www.excelforum.com/member.php...o&userid=32348
> View this thread: http://www.excelforum.com/showthread...hreadid=526916
>