# Drag Formula's to continue a sequence

1. ## Drag Formula's to continue a sequence

Good morning all,

I'm trying to use the dragging ability (little black box at the bottom of a cell when selected) to continue a formula sequence, and the formula refers to another sheet.

For example:
In A1, =Dets!A20
In A5, =Dets!A21
In A9, =Dets!A22

And so on. My current issue is I can select A1 - A12 (A2-4, 6-8, & 10-12 are blank) and drag down, but my sequence keeps skipping.

For example:
A1 =Dets!A20
A5 =Dets!A21
A9 =Dets!A22
A12 =Dets!A41
A15 =Dets!A42

2. ## Re: Drag Formula's to continue a sequence

in a1, a5 and a9 put
=INDEX(dets!A:A,CEILING(ROW()/4,1)+19)
select a1:a12 fill down

3. ## Re: Drag Formula's to continue a sequence

That worked perfectly, thanks a ton!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1