can this be fixed to find for next name
 

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

can this be fixed to find for next name
 

Use rank instead

Chip has examples here

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



--

Regards,

Peo Sjoblom


"fivermsg" wrote in
message ...

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