Forum Discussion
Enable Autospill
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.
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.
6 Replies
matzindergard Remove the @-signs in the formula and it might work as desired.
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.
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.
