Hi,
I am using the following formula for finding position by the obtained marks of a student:
=RANK(X8,$X$8:$X$77)&LOOKUP(MOD(RANK(X8,$X$8:$X$77),50),{1,2,3,4,5,6,7,8,9,10,21,22,23,24,31,32,33,34,41,42,43,44,51,52,53,54;"st","nd","rd","th","th","th","th","th","th","th","st","nd","rd","th","st","nd","rd","th","st","nd","rd","th","st","nd","rd","th"})
in this formula:
X8= the obtained marks of the student
X8 to X77 = is a column where obtained marks of all students are present.
now a single problem is, that this formula skips a positions after two same positions
for example if obtained marks are 350 of two students, this formula gives them first position and skip 2nd position and gives 3rd to the next position holder, and i need to give him 2nd position.
any help please.
I am using the following formula for finding position by the obtained marks of a student:
=RANK(X8,$X$8:$X$77)&LOOKUP(MOD(RANK(X8,$X$8:$X$77),50),{1,2,3,4,5,6,7,8,9,10,21,22,23,24,31,32,33,34,41,42,43,44,51,52,53,54;"st","nd","rd","th","th","th","th","th","th","th","st","nd","rd","th","st","nd","rd","th","st","nd","rd","th","st","nd","rd","th"})
in this formula:
X8= the obtained marks of the student
X8 to X77 = is a column where obtained marks of all students are present.
now a single problem is, that this formula skips a positions after two same positions
for example if obtained marks are 350 of two students, this formula gives them first position and skip 2nd position and gives 3rd to the next position holder, and i need to give him 2nd position.
any help please.