Rank
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
Bruce
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.
Aladin
=======
Posted by Bruce on December 12, 2001 3:19 PM
Thanks again, I will post it to Column M.
Thanks for your response!
