Microsoft Excel Tip #6
In this blog we will discuss multiplying arrays.
First, set up your arrays with the data to be used.
Then, you will want to select the 4×4 box (in this example) where you would want the matrix result to end up.
In the formula bar, you will type =MMULT(