SEQUENCE function
Summary
Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
Syntax
SEQUENCE(4,5)
Example
=TEXT(DATE(YEAR(TODAY()),SEQUENCE(1,6),1),"mmm")
=SEQUENCE(5,6,INT(RAND()*100),INT(RAND()*100))
=SEQUENCE(5,1,1001,1000)
=SEQUENCE(5,6,INT(RAND()*100),INT(RAND()*100))
=SEQUENCE(5,1,1001,1000)