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
Hi Wyn Hopkins
In this instance I think it is possible to do away with helper columns by using COUNTIFS to rank rather than the RANK function itself. The information you need for that has already been collected in the 'No. of Fails' and 'Total' columns.
= IF( NOT(Fails), 1 + COUNTIFS( Fails, 0, Total, ">" & Total ), "--" )
Peter
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.- Thank you sir i got clear idea now but is there any other way or formula to calculate without an extra column
