Repeat a formula with interval
 

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?

Repeat a formula with interval
 

=INDIRECT("'DATA LINK'!F"&ROW(A1)*11+3)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Kees Vos" wrote in message
...
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?

Repeat a formula with interval
 

Here's one way of doing it - put this formula on the first row:

=INDIRECT("'DATA LINK'!F"&ROW()*11+3)

then copy down as required.

Hope this helps.

Pete

On Dec 6, 7:51 am, 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?

Repeat a formula with interval
 

Hey,
Small change and it worked, formula used is
=INDIRECT("'DATA LINK'!F"&ROW(A1)*11+2;TRUE)

Thanx!

"Bob Phillips" wrote:

=INDIRECT("'DATA LINK'!F"&ROW(A1)*11+3)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Kees Vos" wrote in message
...
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?

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?