| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autofill @ intervals
What to be able to return A1 then A4 then A7 and so on in the cell. How do
you do this beside writing the formula. Want to be able to use the autofill at intervals. Thanks, JES |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
autofill @ intervals
Can't use autofill, but if you enter
B1: =INDEX(A:A,ROW()*3-2) You can copy the formula down as far as required... In article , "jejkskpj" wrote: What to be able to return A1 then A4 then A7 and so on in the cell. How do you do this beside writing the formula. Want to be able to use the autofill at intervals. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
autofill @ intervals
Thanks
"JE McGimpsey" wrote in message ... Can't use autofill, but if you enter B1: =INDEX(A:A,ROW()*3-2) You can copy the formula down as far as required... In article , "jejkskpj" wrote: What to be able to return A1 then A4 then A7 and so on in the cell. How do you do this beside writing the formula. Want to be able to use the autofill at intervals. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confidence Intervals | Excel Discussion (Misc queries) | |||
| 5 minutes intervals | Excel Worksheet Functions | |||
| Dates and Intervals | Excel Worksheet Functions | |||
| date intervals | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Linear Mode
