Forum Discussion

Karthicr's avatar
Karthicr
Copper Contributor
Jan 06, 2019
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 ...
excel
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jan 08, 2019

    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

     

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 12, 2019
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
Karthicr's avatar
Karthicr
Copper Contributor
Jan 12, 2019

Thank you wyn for your kind guidance but i cant get the names who got <35 marks only in one subject. to explain correctly i created a table in my excel sheet named "Single subject failures" with all subject names. what i need is, for example the second column shows English. so that column should display the name of the students got <35 marks in english and got >35 marks in all other subjects. i tried pivot table, vlookup and others i cant find a solution. please give me a solution.

 

Karthic

Resources