SOLVED

using sequence function for row numbers in offset

Contributor

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 Replies
best response confirmed by chahine (Contributor)
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)