Hi guys,
I am trying to find a formula to do the following :
I have a list of students with their marks (in each subject) for the 1st and 2nd terms.
Looks like this
A B C
Michel 1st term 2nd term
Math 5 7
French 9 6
English 7 8
What I would like to do the following. Using the max function (=max(B2:C5) in a cell (let's say F5) it would like that in the cell F6 the subject appears automatically, so here it would be 9 French
Thanks a lot for your help
Chris
I am trying to find a formula to do the following :
I have a list of students with their marks (in each subject) for the 1st and 2nd terms.
Looks like this
A B C
Michel 1st term 2nd term
Math 5 7
French 9 6
English 7 8
What I would like to do the following. Using the max function (=max(B2:C5) in a cell (let's say F5) it would like that in the cell F6 the subject appears automatically, so here it would be 9 French
Thanks a lot for your help
Chris