Forum Discussion
GhostCrab
Sep 26, 2025Copper Contributor
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...
techkodainya
Sep 27, 2025Copper Contributor
=LET(
x,E1:E2288,
y,SEQUENCE(ROWS(x)),
z,FILTER(y,x=""),
str,VALUE(INDEX(z,G1)),
rws,VALUE(INDEX(z,G1+1)-str),
SEQUENCE(rws,1,str,1)
)