Forum Discussion
SUBTOTAL, OFFSET, and bogus results
In this formula... =OFFSET(Values,0,0,SEQUENCE(10)) ...Values is a column of ten numbers. And the formula returns ten #VALUE! errors, presumably because Excel can't (yet?) manage an array of arrays...
You need to correct in your offset function. Width that represent how many columns is missing in the formula.
=OFFSET(reference, rows, cols, [height], [width])
The formula must be as below.
=OFFSET(Values,0,0,SEQUENCE(10),1)
=OFFSET(reference, rows, cols, [height], [width])
The formula must be as below.
=OFFSET(Values,0,0,SEQUENCE(10),1)
- Starrysky1988
Actually, no. The width is an optional argument. By default, it has the shape of reference, which is Values in this case. So, because Values is a single column, the width parameter isn't needed.
