Forum Discussion
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 is the issue, although sequence by itself works properly, please check below snapshot
although am using everything as intended for sequence but its spilling wrong value
to my understanding SEQUENCE(COUNTA($A$2:$A$6) in my case will be sequence(5) which is 1,2,3,4,5
it should spill correct values, can someone tell me what is the problem?
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)
2 Replies
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
