Autofill a formula with a series to start next row at the end of the previous series

**mbkr29** · 01-18-2013, 03:50 PM

I basically want my formula to skip every 3 rows. I want to be able to drag down these formulas, in particular the $C2:$C4 (first formula) and $C8:$C10 (second formula), respectively to look like $C14:$C16 for the third row and $C20:$C22 for the fourth row. Currently, when I drag down the first and second row, the third row autofill is $C4:$C6.

Below is my formula. (I am only focused on the portion mentioned above)

=INDEX('OPTION DATA '!$C2:$C4,MATCH(MIN(INDEX(ABS('OPTION DATA '!$C2:$C4-Sheet11!D2),0)),INDEX(ABS('OPTION DATA '!$C2:$C4-Sheet11!D2),0),0))

=INDEX('OPTION DATA '!$C8:$C10,MATCH(MIN(INDEX(ABS('OPTION DATA '!$C8:$C10-Sheet11!D3),0)),INDEX(ABS('OPTION DATA '!$C8:$C10-Sheet11!D3),0),0))

Thank you very much for any help in advance.

**dilipandey** · 01-19-2013, 02:39 AM

Hi mbkr29,

See the attached formula where I have successfully dragged a set of formula while skipping 3 rows. select the yellow range and drag down

skipping 3 rows when formula dragged.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**mbkr29** · 01-19-2013, 10:54 AM

Please look at my sample workbook that I have attached. I am trying to scroll down on "Sheet11:W2" by referencing three cells in another tab. I want W4 to automatically scroll down to include "C14:C16" but it does not. Instead it autofills C4:C6

**dilipandey** · 01-19-2013, 11:09 AM

Hi mbrk29,

See the attached file where I have used a defined name using below formula:-

=OFFSET('OPTION DATA '!$C$2:$C$4,6*ROW('OPTION DATA '!$A1)-6,0)

Marked the required ranges in yellow in option data sheet and then checked them using sum function in sheet11

sample option data.xlsx
Regards,
DILIPandey
<click on below * if this helps>

**jeffreybrown** · 01-19-2013, 11:51 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...23#post3089223

Thread Closed.

Autofill a formula with a series to start next row at the end of the previous series

LinkBack

Thread Tools

Display

Autofill a formula with a series to start next row at the end of the previous series

Re: Autofill a formula with a series to start next row at the end of the previous series

Re: Autofill a formula with a series to start next row at the end of the previous series

Re: Autofill a formula with a series to start next row at the end of the previous series

Re: Autofill a formula with a series to start next row at the end of the previous series

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions