MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Bruce on December 11, 2001 12:43 PM

I use the following formula to rank a number of students up to 200 at times (=Rank(G7,$G$7:G$200). This is based on a series of test throught out a 12 week course. However, we inevitably end up with ties and it shows them ranked the same. We then go to another column which contains the overall individual scores that involves a series of pop-test to break the tie. My question is how can I change the formula so it will calculate this for me?

Thank you

Posted by Bruce on December 11, 2001 12:45 PM

Posted by Aladin Akyurek on December 11, 2001 12:57 PM

Bruce --

In H7 enter: =RANK(G7,G$7:G$200)+COUNTIF(G$7:G7,G7)-1

and copy down.



Posted by Bruce on December 12, 2001 6:47 AM

Thank you very much!!! Works great (Bruce)