Excel formula "Sequence"

Question

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".&nbsp;However, my excel (office 365) doesn’t recognize the “Sequence” command as a formula nor when using the manual entry with &nbsp;for example = {1, 2, 3, 4, 5}.&nbsp;Do I need to activate something? Or what is the matter?Thanks for your help.

jkpieterse · Answer

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.

twifoo · Answer

If you need the sequential numbers 1:5 as argument in a function, you may use ROW(1:5).

cb2019abc · Answer

HiThank 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?&nbsp;

jkpieterse · Answer

This appears to be the official site: https://insider.office.com/en-us/

Forum Discussion

Excel formula "Sequence"

4 Replies

Resources