Thread: Repeat a formula with interval
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Repeat a formula with interval
=OFFSET('DATA LINK'!$F$14,(ROW(A1)-1)*11,0)
copy down


"Kees Vos" wrote:

Hey,

I need Excel to repeat a formula with a interval of 11. My goal is to get
this:
='DATA LINK'!F14
='DATA LINK'!F25
='DATA LINK'!F36
='DATA LINK'!F47
='DATA LINK'!F58

For 9999 rows.

If I use the chain function, Excel fills in F14, F15, F16 etc.

How do I do this?
Reply With QuoteReply With Quote