Excel formula "Sequence"

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


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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies