Forum Discussion
SEQUENCE formula with curly brackets
I have this simple formula, it works as expected up until the SEQUENCE part : In short rws would equal to 32, and srt to 1 I expected this to output the same as SEQUENCE(32,1,1,1), but it outputs j...
Alternatively
=LET(
data, ROW(E1:E2288)/(E1:E2288=""),
start, AGGREGATE(15,6,data, G1),
end, AGGREGATE(15,6,data, G1+1),
IFERROR( SEQUENCE(end-start,,start),
"G1 is too big" )
)or
=LET(
data, TOCOL(ROW(E1:E2288)/(E1:E2288=""),3),
x, @CHOOSEROWS(data, G1),
y, @CHOOSEROWS(data, G1+1),
IFERROR( SEQUENCE(y-x,,x),
"G1 is too big" )
)