How MMULT Function works?? How it can be used??

here is: MMULT()

Simply example:

1. select 10 x 10 cells
2. in formula bar type: =MMULT(ROW(1:10),TRANSPOSE(ROW(1:10)))
3. confirm it by CSE (Control+Shift+Enter)

and you will get simply multiplication table

Hi chullan,

I've used the MMult function in golf scoring. We play a foursome event where we need to use 1 gross score from four players and two net scores from the four players, but the gross ball can't be one of the net balls.

Here is my example

Player1 - Gross = 5 - Net = 4
Player2 - Gross = 6 - Net = 5
Player3 - Gross = 4 - Net = 3
Player3 - Gross = 4 - Net = 4

There are 12 different ways to take one gross score and 2 net scores they are:
The gross Matrix looks like this:
1 0 0 0
1 0 0 0
1 0 0 0
0 1 0 0
0 1 0 0
0 1 0 0
0 0 1 0
0 0 1 0
0 0 1 0
0 0 0 1
0 0 0 1
0 0 0 1

Net Matrix looks like
0 1 1 0
0 1 0 1
0 0 1 1
1 0 1 0
1 0 0 1
0 0 1 1
1 1 0 0
1 0 0 1
0 1 0 1
1 1 0 0
1 0 1 0
0 1 1 0

So the 12 possible combinations are MMult(GrossMatrix, Gross Scores) + MMult(NetMatrix, Net Scores)

I've searched long and wide for a simpler answer to this problem ( without needing to list all possible 12 combinations) and using MMult seems to be the easiest.

I hope that helps.

Hi,

I give an example - with explanations - of a common practical usage of the MMULT/TRANSPOSE set-up in this post, if that's of interest.

In fact, a large proportion of the posts/challenges at my site involve constructions which employ MMULT, so perhaps worth your time having a look: choose MMULT under the Tags section.

Regards

Originally Posted by chullan88

XOR LX - Your website is really awesome..Thanks for the redirect.

Very kind of you to say so!

Cheers!