Home > database >  How to create a diagonal matrix from column with diagonal values using a dynamic array function
How to create a diagonal matrix from column with diagonal values using a dynamic array function

Time:06-28

I have an excel sheet with a column with values I would like to use as a diagonal matrix for some matrix multiplication. I would like to achieve this without actually displaying the diagonal matrix, but only displaying the result of some matrix operation on the diagonal matrix as shown in the example in the picture. For this purpose I would like a dynamic array formula to create the diagonal matrix from which the result can be fed into for example MMULT-function without displaying the diagonal matrix. Any ideas of how this can be done?

enter image description here

  • Related