placing.. 1st, 2nd, 3rd...
 

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

placing.. 1st, 2nd, 3rd...
 

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