Use RANK
http://www.cpearson.com/excel/rank.htm
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"fivermsg" wrote in
message ...
I have a data table with total points b2:b17. I am trying to make a
ranking system to read the points and distinguish 1st through 6th
place.. this is the formula that i am using
=INDEX(A2:A13,MATCH(LARGE(B2:B13,4),B2:B13,0))
but when i use this I am getting the same name when two people have the
same total... Any suggestions?
--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile:
http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=522023