How can I shift cell range contents by using a function?

S

spydog27

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.
 
F

Frank Kabel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a cell into bookmarked table from excel vba 1
SUMIF anomaly - Help Needed 2
Forecast based on latest 26 weeks data 0
Using IF and VLOOKUP for range of cells 5
A Challenge: Detection of first and Last +ve number in a range 1
How do I use formulas using dynamic names 1
Use reference text from one cell in another function call 3
testing range of cells for part of cell content 5

Top