Forum Discussion
Solved
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 kno...
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.
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.
- Yes! It turns out I have to highlight the area and use ctl shift enter. Thank you both so much for your help this is a huge relief. I’m surprised my version doesn’t do it automatically but the fact that you were able to help me work around it makes it alright. Thank you both so much again you have no idea how helpful this is!
matzindergard Good for you, but why are you posting the same question again?