This was couched in terms of your OP, since in subsequent posts you were less
than specific on exactly what X values you were predicting on. Sorry if that
was confusing.

Jerry

"Jerry W. Lewis" wrote:

What is wrong with
=TREND($A$1:$A$100,$c$1:$H$100,$C101:$H101)
(which also sidesteps the redundant 1's in column B)?

Jerry