Solution – Challenge 14 – Student Scoring Highest Marks in a Subject

A proposed solution is listed below for the challenge – Challenge 14 – Student Scoring Highest Marks in a Subject

Put following Array formula in N2

=INDEX(A2:A20,MATCH(1,–(MMULT(–(MAX(B2:K20)=B2:K20),TRANSPOSE((COLUMN(B2:K20)^0)))>0),0))

Put following Array formula in N3

=INDEX(B1:K1,MATCH(MAX(B2:K10),OFFSET(A1,MATCH(1,–(MMULT(–(MAX(B2:K20)=B2:K20),
TRANSPOSE((COLUMN(B2:K20)^0)))>0),0),1,1,COLUMNS(B2:K10)),0))

Put following (non Array) formula in N4

=MAX(B2:K20)

The solution workbook can be downloaded from Solution – Challenge 14 – Student Scoring Highest Marks in a Subject