Excel: Copy formula but skip every 4th row


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


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of October 20, 2014.


For more resources for Microsoft Excel