Mon 13 Jul 2015

Solution - Challenge 12 – Student Scoring Maximum Total Score

By |Monday, July 13th, 2015|Categories: Solutions|Tags: , , , , , , , |0 Comments

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

Sat 18 Apr 2015

Challenge 12 - Student Scoring Maximum Total Score

By |Saturday, April 18th, 2015|Categories: Challenges|Tags: , , , |1 Comment

Download the file related to this problem from here Max Total Score

Given the below grid, I need a formula in N2 and N3 which gives the name of the person scoring the total highest marks adding all subjects together. This, you need to do without a helper column.

For example, in the below grid, 721 is the total highest marks and that is scored by Charlton.

1

Note - You may post your answer in the comments.