Hi,

I have a query regarding, below illustration, where minimum passing marks are fifty, and the scores of four modules are provided. Now my question is, how do i get the results showing marks of any 3 module out of 4, whose scores are above 50.


Pass mark50
MODULE MARKS
NameModule 1Module 2Module 3Module 4
John62464245
i'm not sure I can help but I have a question that might clarify a point for anyone reading this discussion. If all scores for a person are over 50, do you want to select the highest 3? Hi Soybean,

First of all thanks for showing interest in my query.

The criteria should be that, out of four modules the person whose scores are 50 marks or above in any three module should be shown. So I would like to write a formula in excel using IF, AND, OR function to get the output as person passing EXACTLY any three modules out of four.

Hope this HELPS, looking forward for more replies and solution to my query.

Best Regards,

Deepesh.Hi,
Is there anyone who could PLEASE help me with my below mentioned query.