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...
To ensure INDEX returns a scalar (TYPE 1 in this case) as opposed to an array (TYPE 64), you need to explicitly set the [column_num] argument to 1, e.g. INDEX(z,G1,1) and INDEX(z,G1+1,1). You can also get rid of VALUE, as it's not needed in this example. ;)