Forum Discussion
Solved
SEQUENCE function not working
I am using Excel with a 365 subscription and the version is 16.60. It is my understanding that the SEQUENCE function should work but when I open a file with that function it returns #NAME? Any assis...
HansVogelaar and mtarler
I contacted Microsoft support and they went above and beyond to help me out.
It turned out that I needed to run First Aid and restart my computer. Excel is now able to run all dynamic array functions.
Thank you both for your help!
Yes, thank you HansVogelaar this is on a Mac.
mtarlerI will look into whether there are multiple copies of excel. It is a new machine, so I do not think so. FILTER() & UNIQUE() also are not functional.
HansVogelaar and mtarler
I contacted Microsoft support and they went above and beyond to help me out.
It turned out that I needed to run First Aid and restart my computer. Excel is now able to run all dynamic array functions.
Thank you both for your help!