Forum Discussion
Solved
using sequence function for row numbers in offset
Hello guys I have one issue, when am using the offset formula, now as you now offset needs row parameter, when i use sequence function for row parameter, i get an error, why? am not getting what ...
OFFSET() doesn't work with array, you may check on more simple variant =OFFSET(A1, {1;2} , 0).
Formula could be
=$A$2:INDEX($A$2:A1000,COUNTA(A:A)-1)
OFFSET() doesn't work with array, you may check on more simple variant =OFFSET(A1, {1;2} , 0).
Formula could be
=$A$2:INDEX($A$2:A1000,COUNTA(A:A)-1)
- Thank you
