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?