Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Download the Workbook here: http://bit.ly/2l28CWK

Visit Part 1 here: https://youtu.be/Nfu0fvbnccU
And Part 2 here: https://youtu.be/vC9S0oCa_Xk

In this video I build on the Matrix Multiplication (MMULT) formula - from Part 2. In the MMULT formula, I used the TRANSPOSE function to be able to dynamically add new columns to the original list. The problem with TRANSPOSE is that it requires Control shift Enter (CSE). In the best case, I'd rather have a formula that doesn't require CSE.

In Part 3, I replace the TRANSPOSE part of the MMULT formula with alternate formulas. The idea is to use the ROW function, but somehow get the rows to be dependent on the columns.

I first set out to use the ROW and INDIRECT functions. Then I use the ROW, INDIRECT and ADDRESS Function and finally I don't use INDIRECT at all, but instead the ROW and INDEX function (This one became my favorite). The great thing about the INDEX function is that it returns a cell reference instead of a cell value if you use it after the : sign in a formula. (INDEX is an amazing function!). Do look into it in more detail if you don't know it well.

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus