***Rank with tie breakers***

[cafeaulait]

<TABLE class=tborder id=post2534626 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt2 style="BORDER-TOP-WIDTH: 0px; BORDER-RIGHT: #ffffff 1px solid; BORDER-BOTTOM-WIDTH: 0px; BORDER-LEFT: #ffffff 1px solid" width=175>Hello Everyone

I am reposting this as I haven't received a correct solution. I used to use this formula and have forgotten it. I want to rank when I have tie breakers. However the solution I have been given results in the following.


362 mins 1st
362 mins 1st
500 mins 3rd should be 2nd
900 mins 4th should be 3rd

Many thanks for your help.


</TD><TD class=alt1 id=td_post_2534626 style="BORDER-RIGHT: #ffffff 1px solid"><!-- report button --><!-- / report button --><!-- icon and title -->





















</TD></TR></TBODY></TABLE>

 

[Datsmart]

Was this not answered here?
http://www.mrexcel.com/forum/showthread.php?t=513469

 

[cafeaulait]

john,

sorry, no as i said in my post, the answer was not what i had requested. the ranking does not continue consecutively when there are tie breakers!