Common SEQUENCE questions usually involve formula errors, unexpected results, and repeated use across cells; this FAQ includes 3 common questions and a short glossary.
FAQ
What should I do if SEQUENCE shows an error after I enter it?
- Check whether the argument types are correct and make sure numeric arguments do not contain text or extra spaces.
- Check the commas, parentheses, and function spelling in the formula.
- If needed, clean the source data and enter the formula again.
Why does the SEQUENCE result not match what I expected?
- Check the order of
rows,columns,start, andstep. - Make sure the target area has enough room to display the returned array.
- Review the cell format and then verify the formula arguments again.
How can I use SEQUENCE across multiple cells?
- Enter the SEQUENCE formula in the starting cell.
- Confirm that the returned array range matches what you expect.
- Before reusing the formula in another area, check references and make sure result ranges will not interfere with each other.
Glossary
| Term | Definition |
|---|---|
| SEQUENCE | A function that returns an array of sequential numbers or dates. |
| Argument | An input item in a function that controls the result, such as rows, columns, start value, or step. |
| Array result | A set of results returned by one formula across multiple cells. |