| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat a formula with interval
I found a similar post but I have had no success with the formula that was
given to the poster. Please help. I need Excel to repeat a formula with an interval of 4. My goal is to link two spreadsheets within the same workbook and get the following: ='DATA LINK'!B1 ='DATA LINK'!B5 ='DATA LINK'!B9 ='DATA LINK'!B13 ='DATA LINK'!B17 For 9999 rows. If I use the chain function, Excel doesn't fill in the appropriate interval. How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat a formula with interval | Excel Worksheet Functions | |||
| Formula used by Excel to determine y-axis interval in chart | Excel Discussion (Misc queries) | |||
| I NEED TO USE A FORMULA #1-39 TO REPEAT ONCE 5 AT A TIME | Excel Discussion (Misc queries) | |||
| How do you repeat a function in a formula | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Threaded Mode
