Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I shift cell range contents by using a function?
I am doing some simple forecasting. I want to be able to enter the new data
value into a cell and then have a cell range automatically update with the five most recent data points that the user has entered. Then the forecast is made based on the new data as well as the most recent- without having to add cells and what not. Hope this makes sense. |
#2
|
|||
|
|||
Hi
how would you enter your data. In separate cells within one row. Say A1:A100? Or how would you define which are your most recent ones? -- Regards Frank Kabel Frankfurt, Germany spydog27 wrote: I am doing some simple forecasting. I want to be able to enter the new data value into a cell and then have a cell range automatically update with the five most recent data points that the user has entered. Then the forecast is made based on the new data as well as the most recent- without having to add cells and what not. Hope this makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |