| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula used by Excel to determine y-axis interval in chart | Excel Discussion (Misc queries) | |||
| Repeat formula on second sheet? | Excel Discussion (Misc queries) | |||
| Excel repeat formula ..??? | Excel Worksheet Functions | |||
| I NEED TO USE A FORMULA #1-39 TO REPEAT ONCE 5 AT A TIME | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
![Kees Vos[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
