Wrong output for 'F6' students

Dear friends,
I have remark in column ‘BB’ based on the total in column ‘AN’. In column ‘BD’ there is a rank of the students in the class. The formula is working fine but it’s not giving serial numbers to ‘F6’ remark students. It should be as per their occurrence in the result sheet. I have inserted a expected output in column ‘BE’. The ‘F6’ students should have the numbers from 10 to 13 but now it’s showing 10 for all 4 ‘F6’ students which I don’t want. ‘F’ stands for ‘Fail’. ‘F1’ means fail in 1 subject and so on …

Please see the attached file and give me a solution.

Thanking you in anticipation.

Sincerely,

Mukesh

Thank a lot!

Hi bebo021999,
Excellent! It's working fine but I have one little problem after entering it in my original file. The number of students are not fixed in each class. It varies from class to class. So this formula gives error after the given range in the formula. Is it possible to give not fixed range so that this formula will work all the classes without error ignoring the number of students.

You have the idea of this formula so I posted it on this a solved thread . Sorry for that.

Thankinng you in anticipation.

Regards,

Mukesh

Here is a file. Why the color of column 'bc and bd' change to blue? I want it black. In column 'bc' there is some numbers with decimals, why? In column 'bd' there is output 'n/a' which I want '0' for blank student entries. In short if there is '0' output in column total 'an' then the output in column 'bb' should be '0'.

Thank you.

Mukesh