I want to create marks shet with following Criteria
There is 6 subject(Mar, Hin, Eng, Math, Sci, Soc) out of 100 marks 5 subject and out of 150 marks 1 subject.
in each subject obtained marks
Mar - 62 (out of 100), Hin - 64 (out of 100), Eng - 48 (out of 100), Math - 52 (out of 150), Sci - 49 (out of 100), Soc - 55 (out of 100)
Which formula to use to minimum obtained marks.
Assuming your marks list is in range B2:B7, and it's respective total marks in C2:C7, the formula would be
=INDEX(B2:B7,MATCH(MIN(B2:B7/C2:C7),B2:B7/C2:C7,0)) confirmed as an array formula (CSE formula)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks