Forum Discussion
Solved
Drag fill not continuing or recognising pattern for formulae.
So I am attempting to use drag fill to speed up my data entry input. I am using the OFFSET function where I have the following: =OFFSET($A$1,19,0) =OFFSET($A$1,38,0) =OFFSET($A$1,57,0) In ...
You are correct that Excel fails to recognize such patterns. So you have to specify the offset explicitly.
Let's say your first formula is in D2.
Change the formula to
=OFFSET($A$1,19*(ROW(D2)-ROW($D$2)+1),0)
and fill down. Alternatively, use
=INDEX($A:$A,19*(ROW(D2)-ROW($D$2)+1)+1)
You are correct that Excel fails to recognize such patterns. So you have to specify the offset explicitly.
Let's say your first formula is in D2.
Change the formula to
=OFFSET($A$1,19*(ROW(D2)-ROW($D$2)+1),0)
and fill down. Alternatively, use
=INDEX($A:$A,19*(ROW(D2)-ROW($D$2)+1)+1)
- Worked perfectly. Thank you.
