Hi everybody !!
=IF(AH13=0,"",SUMPRODUCT(((($AK$13:$AK$53="Pass")*($AI$13:$AI$53)+($AK$13:$AK$53="Fail")*($AI$13:$AI$53/50))>AI13/IF(AK13="Pass",1,50))*1)+1)
I used the above formula for 1 class of students' ranking in the same sheet. It will rank based on percentage then look for whether the student pass or fail. Then,the group of Pass student will be on upper ranking then group of Fail student will be lower ranking.
Now, will somebody help me to make a formula for class batch ranking (column AM)?
Which is the ranking will continuous between other workbooks (let's say for 3 classes) based on the criteria (percentage and (Pass or Fail)).
Here, together I attached the workbook.
I am a new leaner of excel with formula.
I hope members willing to help me to solve these problems please. Thanks a lot
Bookmarks