using sequence function for row numbers in offset

[chahine]

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?

[#2 · Accepted solution]

@chahine 

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)

[#3]

Thank you