Forum Discussion

Kayllen's avatar
Kayllen
Copper Contributor
Aug 25, 2020
Solved

Transpose function returns #VALUE

Hi all,

 

I am in desperate need of help. I have searched the transpose problems but have not seen an issue like mine. 

 

I am trying to do a matrix, using MMULT and TRANSPOSE but it keeps returning #VALUE. 

The code I am running is:

=MMULT(ARRAY;TRANSPOSE(ARRAY))

I have correctly selected all the cells and pressed command + Enter but it still gives me #VALUE.

 

I have tried just using the Transpose function as a test and that also doesnt seem to be working

 

I have attached the excel sheet I am using. Cell references AF320:AN328 this is where i am trying to put the matrix.

 

Your help will be greatly appreciated

 

excel
Excel on Mac

7 Replies

    • Kayllen's avatar
      Kayllen
      Copper Contributor
      Aug 25, 2020

      Hi, Detlef_Lewin 

       

      The desired outcome is meant to be a 9x9 matrix. I have since then come right. 

       

      Thanks.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 25, 2020

    Kayllen Not sure what you are trying to achieve, but when I opened your file there were several @-signs in the formula in AF320. Removed these and then cleared all the other cells below and to the right.

    Then numbers appeared in the range AF320:AN328. Is that what you need?

Resources