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
15
1
15
1
15
1
15
I tried to accomplish this by using MAKEARRAY and TOCOL but I keep getting the #CALC! error.
Excel_Rept_Seq_Numbers.png
What am I missing here? Any help is greatly appreciated...
Thanks in advance!
P.S.:
Same question also posted on Microsoft Tech Community forum: https://techcommunity.microsoft.com/...845224#M194666
Bookmarks