Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to create rolling windows from a column
Please help me out.
For example, suppose I have a series below. 2 3 4 5 6 7 If I want to have 3-observation rolling windows, how could I accomplish the task? The outcome I want is as follws. 2 3 4 5 3 4 5 6 4 5 6 7 thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
to create rolling windows from a column
Hi,
Suppose your data is in A1:A6 then enter this formula in any cell and copy it down three rows and over 4 columns. =OFFSET($A$1,ROW(A1)-1+COLUMN(A1)-1,) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Moohwan" wrote: Please help me out. For example, suppose I have a series below. 2 3 4 5 6 7 If I want to have 3-observation rolling windows, how could I accomplish the task? The outcome I want is as follws. 2 3 4 5 3 4 5 6 4 5 6 7 thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a rolling 12 week graph | Charts and Charting in Excel | |||
How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
create a rolling sum?? | Excel Worksheet Functions | |||
Create Windows Directories from column entries? | Excel Discussion (Misc queries) | |||
Create Windows Directories from column entries? | Excel Worksheet Functions |