Home

Excel formula "Sequence"

cb2019abc
New Contributor

Hi there,

I would like to make an array constant as it is described under your webpage "support.office.com"-Webpage "Guidelines and examples for array formulas". 

However, my excel (office 365) doesn’t recognize the “Sequence” command as a formula nor when using the manual entry with  for example = {1, 2, 3, 4, 5}. 

Do I need to activate something? Or what is the matter?

Thanks for your help.

4 Replies
This is a relatively new function. Try if updating your Excel helps. If not, you may have to join the Office Insider program and update again to get the very latest builds.
If you need the sequential numbers 1:5 as argument in a function, you may use ROW(1:5).

Hi

Thank you for your help. I updated the excel as you suggested - the function is still not available. How do I join the Office Insider program?

 

This appears to be the official site: https://insider.office.com/en-us/
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies