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