MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Bruce on December 12, 2001 11:48 AM

Attempting to rank a class of up to 200 students.

The formula in G column is =+(C9*0.1)+(D9*0.4)+(E9*0.1)+(F9*0.4)which gives the academic average.

The formula in A column is =Rank(G7,$G$7:G$200) which gives the class academic ranking from 1 to 200 students based on the academic average in G column, and inevitably there are ties.

In M column is the overall average (PoP test, etc) with the formula =+(G7+H7+J7+I7+K7+L7)/6. When academic ties occur and there are individuals ranked the same in (G column), I use the overall average in (M column) for the tie breaker. Is there a formula I could use that would include the overall average (M column) when there are ties in ranking in A column?

Thank you


Posted by Jack on December 12, 2001 12:03 PM

Aladin answered on feed 9511???? Whats wrong?

Posted by Aladin Akyurek on December 12, 2001 12:10 PM

Bruce --

Applying the tie-breaking rank formula I suggested earlier to column G (as you asked for) is apparently not good enough. Right?

Why don't you apply it instead on column M?

By the way, you can use

=AVERAGE(G7:L7) instead of =+(G7+H7+J7+I7+K7+L7)/6 in M.



Posted by Bruce on December 12, 2001 3:19 PM

Thanks again, I will post it to Column M.

Thanks for your response!