Forum Discussion

leolapa's avatar
leolapa
Brass Contributor
Jun 12, 2023

Column Array Repeated Sequence of Numbers

Hi,   I have a sequence of two numbers 1 and 15 stacked on top of each other "=SEQUENCE(2,,,14)".   I just want to have that pattern repeated 4x in one single "spilled" array, like this:   1 1...
Excel
Formulas and Functions
  • JosWoolley's avatar
    JosWoolley
    Jun 12, 2023

    OliverScheurich 

     

    Slightly simpler might be:

     

    =TOCOL(IF(SEQUENCE(,B2),A2:A3),,1)
JosWoolley's avatar
JosWoolley
Iron Contributor

OliverScheurich 

 

Slightly simpler might be:

 

=TOCOL(IF(SEQUENCE(,B2),A2:A3),,1)
leolapa's avatar
leolapa
Brass Contributor
Jun 12, 2023
With the bonus that also works in case the number sequence grows to more than two numbers.

Thanks both of you for the great suggestions!

Resources