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...
As an alternative to setting both row and column indices in the INDEX function, you could use the '@' operator to truncate any array output to the value of its initial (scalar) element.
= LET(
y, SEQUENCE(ROWS(x)),
z, FILTER(y, x=""),
str, @INDEX(z, k),
rws, @INDEX(z, k+1)-str,
return, SEQUENCE(rws,1, str, 1),
return
)
[note: I have used defined names for 'x' and 'k']