Below is a proposed solution for the challenge Challenge 12 – Student Scoring Maximum Total Score
Put following Array formula in N2
=INDEX(A2:A20,MATCH(MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0))),
MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)),0))
Put following Array formula in N3
=MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)))
The solution sheet for this can be downloaded from Solution – Challenge 12 – Student Scoring Maximum Total Score