Create one-dimensional array from single cell (repeating that cells value n times)

[kderoeck]

Hi,

I'm looking for an excel formula that can create a one-dimensional array from a single cell, repeating the cells value n times. e.g. cell A1 has value 200, the result of the formula should be an array that looks like this: {200,200,200,200,200,200,200}

The challenge lies in the fact that I would like to avoid using VBA as I'm pretty sure the same result can be achieved through excel formulas.

Kind regards,
Koen

 

[Rick Rothstein]

It depends on which desktop version you have. Therefore ..

Which desktop version has the SEQUENCE function in it?

 

[Peter_SSs]

Which desktop version has the SEQUENCE function in it?

365

 

[Rick Rothstein]

365

I thought 365 was an online only version... it is available as a desktop version too?

 

[Peter_SSs]

I thought 365 was an online only version... it is available as a desktop version too?

AFAIK the desktop version is the only version where all the 365 features are available.

 

[Rick Rothstein]

Thanks... I have to check it out. I don't know why I thought it was an online only thing.