software

I am using this formula to automatically quot;displayquot; 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: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=526916Use rank instead

Chip has examples here

www.cpearson.com/excel/rank.htm
--

Regards,

Peo Sjoblomquot;fivermsgquot; gt; wrote in
message ...
gt;
gt; I am using this formula to automatically quot;displayquot; a name from a list of
gt; total points to make a rank that will consistantly change as the points
gt; change.. I only want to display the top six names..Right now this
gt; formula will do that but when there is a tie it displays the same name
gt; twice and will skip the next name in the order.. any suggestions??
gt;
gt; INDEX(A2:A13,MATCH(LARGE(B2:B13,1),B2:B13,0))
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=526916
gt;