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

Mon 13 Jul 2015

Solution - Challenge 8 – Counting Number of single 1s in Rows in a Grid

By |Monday, July 13th, 2015|Categories: Solutions|Tags: , , , , , |1 Comment

Below is a proposed solution for the challenge - Challenge 8 – Counting Number of single 1s in Rows in a Grid

Enter below Array formula -

=SUM(--(MMULT(--(A1:E10=1),TRANSPOSE(COLUMN(A1:E10)^0))=1))

Note - Array Formula is not entered by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. If you are copying and pasting this formula, take F2 after pasting and CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually.

The worksheet related to this solution can be downloaded from Solution - Challenge 8 – Counting Number of single 1s in Rows in a Grid

Sat 17 Jan 2015

Challenge 8 - Counting Number of single 1s in Rows in a Grid

By |Saturday, January 17th, 2015|Categories: Challenges|Tags: , , , , |1 Comment

Suppose you have a grid like below. The challenge before you is to count number of rows which have only single 1. See the grid, the yellow highlighted ones are containing 1 only once. The answer is 3 for this problem.

You have to give me a single formula for the same. The relevant Excel can be downloaded from Grid

1

Note - You may choose to post the response in comments section.