Forum Discussion

leolapa's avatar
leolapa
Brass Contributor
Jun 12, 2023
Solved

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)
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 12, 2023

leolapa 

=MAKEARRAY(B2*2,1,LAMBDA(r,c,INDEX(A2:A3,IF(ISODD(r),1,2))))

You can try this formula.

 

JosWoolley's avatar
JosWoolley
Iron Contributor
Jun 12, 2023

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