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