Forum Discussion
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 is the command I use
=IF(K8=0,RANK(H8,$H$8:$H$39,0),"--")
it gives the rank but the final rank is one number more (it should be 8 but it shows 9)
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
14 Replies
- 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
