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.
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.