Thanks for your reply - I'm assuming that the
"TREND(known_y's,known_x's,new_x's,const)" line is a formula to be
copied down the column. However, I'm finding it difficult to implement
successfully, and thus I believe a Visual Basic macro would (hopefully)
do the trick.

Does anyone have any suggested macros designed to tackle this?

Thanks again,
Steve


Julian Wrote:
Check out:

TREND
Show All
Hide All
Returns values along a linear trend. Fits a straight line (using the
method of least squares) to the arrays known_y's and known_x's. Returns
the
y-values along that line for the array of new_x's that you specify.

Syntax

TREND(known_y's,known_x's,new_x's,const)



--
|
+-- Julian
|


--
smurray444
------------------------------------------------------------------------
smurray444's Profile: http://www.excelforum.com/member.php...o&userid=28956
View this thread: http://www.excelforum.com/showthread...hreadid=506070