View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fivermsg
 
Posts: n/a
Default 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