Repeat a formula with interval

[Kees Vos]

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?

 

[Bob Phillips]

=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)

 

[Pete_UK]

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

 

[Kees Vos]

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

Thanx!

 

[Teethless mama]

=OFFSET('DATA LINK'!$F$14,(ROW(A1)-1)*11,0)
copy down