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.
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.
- 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?
- Are you certain that you have dynamic arrays? Office 365 has to be updated past a particular build version to have dynamic arrays, so you may need to update your software. Your formula works on my machine (office 2016), but I have to enter it using the old method of selecting a range large enough for the array and then clicking in the formula bar and hitting Ctrl+Shift+Enter.
