Forum Discussion
Why do I have a #NAME error in my sequence formula?
Hi all
I have Microsoft 365 with Excel version 2506. I started using =SEQUENCE formula today and it was working then randomly all my =SEQUENCE cells changed to #NAME I have checked the formula for typos multiple time, even had Copilot check for typos. I then had Copiolit create me a formula, and that still didn't work. Is there a reason I am getting #NAME error when there are no typos and my Excel is up to date? Thanks in advance.
J
1 Reply
The version is good.
It's possible the #NAME? is not from SEQUENCE but from something else in the formula. If you're able to post an example of one of the SEQUENCE formulas you're using it would go a long way in resolving the error.
You might also inspect the function arguments menu:
The above results in #NAME? because I provided a named item that does not exist for the rows argument.
