Forum Discussion
Problem in Rank command
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
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- Hi I would add a column with a formula like =COUNTIFS( RowOfResults, "<35") then copy that formula down and then do a single =COUNTIFS( ColumnOfFormula, 1 ) that would count how many times the COUNTIFS < 35 resulted in exactly 1
Thank you for you guidance sir but till now i cant understand the problem if possible can you explain it more clearly why it not worked previously and now working
- So the rank formula is being performed regardless of your IF statement. The Rank 8 is achieved by student 3. it is not displayed since the IF statement is applied and therefore "--" is shown instead of 8.
To avoid the RANK being calculated on "ineligible" entries then the score needs to be set to 0 - hence I added a new column doing this. The RANK is then worked out on this new column of "eligible" scores.