If you use the formula =average(a1:aX) where X is the cell immediately above
then each month you could replace the formula with the actual and the future
months will show the correct average.

"DangerMouse" wrote:


Hi all,

I'm hoping and anticipating that theres a really simple solution to
this question but I can't seem to get my head around it. Any advice you
could provide would be much appreciated.

I'm simply calculating hit rate, or average on a monthly basis, and I
want this data to inform future months in a predictive fashion.

Thus I have 10 in Jan, 5 in Feb, my avarage is obviously 7.5, thus I
would like all months after Feb to predict the "hit" figure to be 7.5.


I would like this to work on a rolling basis as evidently as the actual
figures are available the average changes and thus so does the
prediction.

I appreciate this isnt the most scientific way to model things but any
assistance would be appreciated.

Thnx


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=553165