Find Minimum Value After Data Is Normalized

[lokvan]

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.

[Excel Fox]

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)