May 02 2021 07:06 PM
Hello, I need urgent help. I am trying to acquire a matrix by using a formula on a set of data, but instead of the formula spitting out a matrix, I just get the #VALUE symbol in one cell. I don't know how to tell the program that the data need to spill into a matrix. Is there some setting I'm missing? Any help would be greatly appreciated. I am running the newest version of excel.
May 02 2021 08:51 PM
@matzindergard Remove the @-signs in the formula and it might work as desired.
May 03 2021 05:59 AM
@Riny_van_Eekelen Thank you for responding, I'm not quite sure what you mean by @-signs, my formula looks exactly like your screenshot before and after I hit enter. It seems to work on my peers computers, but its frustrating because I can't get it to work on my person excel.
May 03 2021 06:45 AM
May 03 2021 06:53 AM
Solution@matzindergard When I open your file it looks like this:
As @JMB17 suggests, your Excel version might not like the array formula and requires Ctrl-Shift-Enter.
May 03 2021 08:38 AM
May 03 2021 08:50 AM
@matzindergard Good for you, but why are you posting the same question again?
May 03 2021 06:53 AM
Solution@matzindergard When I open your file it looks like this:
As @JMB17 suggests, your Excel version might not like the array formula and requires Ctrl-Shift-Enter.