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)
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