Copy formula but skip every 4th row

[sumsum213]

Hi, I'm trying to copy a formula down, but need it to skip 4 rows. An example is below. I'm imagine this is an easy one, but I'm just not getting it.

=sheet1!D8
=sheet1!D9
=sheet1!D10

<tbody>
</tbody>

 

[István Hirsch]

You can do this using Excel custom list:

Enter into A6:

#Sheet1!D8

Then select this cell with the 3 blank cells below it.

Go to Excel Options/Popular, click on Edit Custom Lists in the middle of the window.

Click Import, then OK, OK.

Now drag down the fill handle at the right bottom corner of the four cells you have selected, as long as needed.

Select the column and replace # with =

(Excel 2007)

 

[bbott]

bbott, never mind, I just got it. Thank you so much, you've saved me hours of work!!!

Ok, I spoke too soon. It worked for the first one, but seems to be putting it in the 4th row and not the 5th row. I tried changing the 4 to a 5, but that's not working either. OMG, I'm sorry to be annoying. Here's what the formula says as it copies down- =IF(MOD(ROW(A266)-262,4)=0,INDEX(Attendance!C:C,8+INT((ROW(A266)-1)/4)),"")

If you want it in every 5th row change both of the 4s to 5s:

=IF(MOD(ROW(A1)-1,5)=0,INDEX(Sheet1!D:D,8+INT((ROW(A1)-1)/5)),"")