Excel formula "Sequence"

Copper 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/