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?