Copying a formula and skipping lines

  • Thread starter Thread starter Stephen Rammer
  • Start date Start date
S

Stephen Rammer

I have a formula which contains two cells which are not
adjacent. (E14/E20). I want to copy this formula so it
skips 6 lines for every time I copy the formula downwards
in the spreadsheet...e.g. (E20/E26), (E26/E32) etc...

Is there any smart way to do this or will I have to do
this manually?

Thanks alot
Stephen
 
Hi Stephen
assuming your formula starts in F1 (result should be E14/E20 for F1)
insert the following in F1:
=INDIRECT("E" & (ROW()-1)*6+14) / INDIRECT("E" & (ROW()-1)*6+20)
copy down

HTH
Frank
 
Back
Top