Hi,

I need to calculate a projected figure, based on previous months...

i.e;

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
123 345 677 899 1002 1400 ??? ??? ??? ???
??? ???

The number is cumulative from month to month....

I have previously used the average of the difference between the months, but
this is not that great to use...

Are there any functions in excel that can do this for me?

Many thanks,


Mark.

Try using a moving average average.

Tools - Data Analysis - etc

If the Data Analysis command doesn’t appear on the Tools menu, you must
install the Analysis ToolPak

http://office.microsoft.com/en-us/as...864801033.aspx


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=490696

Thanks,

I had a look at that, but found a function called Forecast, which seems to
be doing the trick for me!!!

Thanks!

"tghcogo" wrote:


Try using a moving average average.

Tools - Data Analysis - etc

If the Data Analysis command doesnt appear on the Tools menu, you must
install the Analysis ToolPak

http://office.microsoft.com/en-us/as...864801033.aspx


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=490696

Mark Stephenson Wrote:
Hi,

I need to calculate a projected figure, based on previous months...

i.e;

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV
DEC
123 345 677 899 1002 1400 ??? ??? ??? ???
??? ???

The number is cumulative from month to month....

I have previously used the average of the difference between the
months, but
this is not that great to use...

Are there any functions in excel that can do this for me?

Many thanks,


Mark.

Hi Mark

You might find the attached useful, look in the Worksheet Functions
sheet


+-------------------------------------------------------------------+
|Filename: Forecast etc.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4096 |
+-------------------------------------------------------------------+

--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=490696