Forum Discussion
Solved
Problem in Rank command
Hello I am a school teacher working in excel for creating rank sheet of students based on their subject score but I found a problem and I have no solution to it. if anyone has kindly guide me. This ...
So your issue is that student number 3 is ranked 8, but the IF statement is excluding them so the 8 is not displaying.
If you want the ranking to apply after applying the IF checks then I'd add an extra column to change the score to 0 if the conditions aren't met.
see attached
Are you able to attach a file with a copy of the values you have in H8 to H39 ?
SIr i am attaching my file with this please guide me to rectify the problem
So your issue is that student number 3 is ranked 8, but the IF statement is excluding them so the 8 is not displaying.
If you want the ranking to apply after applying the IF checks then I'd add an extra column to change the score to 0 if the conditions aren't met.
see attached
- Dear sir
Can you guide me to select the names of the students got less than 35 marks in only one subject in the above file. i tried diff methods for the last one week i cant
