Matrix Multiplication

[Guest]

I am trying to match a calculation.

The calculation is

Matrix1[8 x 8] * Matrix2[8x1] = Matrix3[1 x 8]

Where Matrix[ rows x columns ]

I have the values for Matrix1 and Matrix3, so I need to solve for Matrix2.
Does anyone know how to do this using the matrix functions in excel, I was
having a hard time.

Thanks for your help

 

[Guest]

Matrix 3 will be an 8×1 matrix, not a 1×8 matrix.
Multiply both sides on the left by the inverse of matrix 1. Use MINVERSE.