R
Robin
Hi all,
I am preparing a marksheet for a class.
Students gets marks as well as grade (A, B, C, D, E)
I rank the position in class following the most A the students get in the
exam followed by B to E.
If two students get same numbers of A, B etc, position will be decided by
the percentage.
What is a formula to rank them should there be a tie in grade?
I used the formula below in cell K2 to find the student with most A.
=B2+C2/10+D2/100+E2/1000+F2/10000+G2/100000+H2/1000000+I2/10000000+J2/100000
000
The percentage is in L2.
The rank is in M2 .. what formula should I used in M2 to break the tie in K2
if L2 (the percentage) to to be used.
Please help. Thank you.
I am preparing a marksheet for a class.
Students gets marks as well as grade (A, B, C, D, E)
I rank the position in class following the most A the students get in the
exam followed by B to E.
If two students get same numbers of A, B etc, position will be decided by
the percentage.
What is a formula to rank them should there be a tie in grade?
I used the formula below in cell K2 to find the student with most A.
=B2+C2/10+D2/100+E2/1000+F2/10000+G2/100000+H2/1000000+I2/10000000+J2/100000
000
The percentage is in L2.
The rank is in M2 .. what formula should I used in M2 to break the tie in K2
if L2 (the percentage) to to be used.
Please help. Thank you.