How to Use the Excel MMULT Function for Matrix Operations

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/mmult-function-file

[@wayneedmondson1065]

Hi Leila.. this is an excellent 3-part series for anyone wanting to understand array formulas and matrix manipulations. I learned a lot. Thanks for Part 2 of 3. Double thumbs up!!

[@excelisfun]

Great to have you as part our our amazing Excel Online Team!!!

[@LeilaGharani]

Thank you so much Mike. That means a lot to me!

[@excelisfun]

Go Team!!

[@davidnorth4703]

Mike & Leila Thank you both for helping this old man get through the amazing world of Excel, it always amazes me that more Excel users stop at VLOOKUP & PIVOT TABLES.

[@LeilaGharani]

Thank you David. Yes, the ones that stop at VLOOKUP are missing out on all the fun :-)

[@excelisfun]

That is for sure!!! And we do NOT like to miss out on fun : )

[@makisalimhussain2334]

Thanks Leila, it is such a great tutorial especially the MMULT function part.
But, I prefer to obtain the first array in different way which I believe it is shorter especially if the conditions are many but not only 3.
Instead of writing (B4:D53=P3)+(B4:D53=P4)+(B4:D53=P5) which is equal to
{1,1,0;1,0,1;0,0,0;0,0,0;0,0,0;0,1,0;0,0,1;0,0,0;0,1,0;0,0,0;0,1,0;0,0,1;0,0,0;0,1,0;0,1,0;0,1,0;0,0,0;1,0,0;1,0,1;0,0,1;1,0,1;0,1,0;0,1,1;0,1,1;0,0,0;0,0,0;0,0,0;0,0,0;0,1,0;0,0,1;0,1,0;0,0,0;0,0,0;0,1,0;0,0,0;1,0,1;1,1,0;0,0,0;0,0,0;0,0,0;1,1,0;0,0,0;0,0,0;1,0,0;0,0,1;1,0,1;0,1,0;0,0,0;0,0,0;0,1,0}
I prefer to obtain the same result by using COUNTIFS function which is COUNTIFS(P3:P5,B4:D53) resulting
{1,1,0;1,0,1;0,0,0;0,0,0;0,0,0;0,1,0;0,0,1;0,0,0;0,1,0;0,0,0;0,1,0;0,0,1;0,0,0;0,1,0;0,1,0;0,1,0;0,0,0;1,0,0;1,0,1;0,0,1;1,0,1;0,1,0;0,1,1;0,1,1;0,0,0;0,0,0;0,0,0;0,0,0;0,1,0;0,0,1;0,1,0;0,0,0;0,0,0;0,1,0;0,0,0;1,0,1;1,1,0;0,0,0;0,0,0;0,0,0;1,1,0;0,0,0;0,0,0;1,0,0;0,0,1;1,0,1;0,1,0;0,0,0;0,0,0;0,1,0}
Maki S. Hussain
Iraq

[@aricosman5354]

You are genius Mrs Leila

[@LeilaGharani]

I wish : ) extremely far from it. Thank you very much though for the support & the kind words.

[@raghuv7114]

No doubt at all. She is genius and also best teacher too.

[@RajendraPatel.]

Nice tips ever I learned in my Excel life. Thanks

[@LeilaGharani]

Glad it was helpful!

[@kangsungho1752]

I don't like Sumproduct to have CtrlShiftEnter, either.
Great to know you have a common thing with me. :)

[@farzanmoha8935]

Hi Leila,
Happy nowrooz
How could I find the matches in different rows that should have more than one match cell to be counted as a match and put their assigned ”for example assigned actual” in one row?

[@LeilaGharani]

Merci - happy eid to you too. The Aggregate function is good one to use to find many matches. Depending on your data set you'll have to tweak it a little bit. I show the formula here: ruclips.net/video/gu4xJWAIal8/видео.html and here: ruclips.net/video/ULa7nQrMvoc/видео.html.

[@mayankkapoor6155]

Superb and....

[@rvgiri]

Great to know about this...

[@hosseinhosseinpoor4845]

سپاس

[@doperich7099]

how to form series of 1,2,3 in column without copy paste?.like cell a1-1,a2-2,a3-3 again a4-1 ,a5-2,a6-3

[@LeilaGharani]

Maybe =IF(MOD(ROW(),3)=0,3,MOD(ROW(),3)) -- you can find a detailed explanation of MOD here: ruclips.net/video/tLufL2M1TEs/видео.html.

[@doperich7099]

thnks a lot.......

[@LeilaGharani]

You're welcome :)

[@Scaw]

@@doperich7099 =MOD(ROW()-1,3)+1 works too.

[@prajwalshetty2047]

👍🇮🇳