Is it possible to generate a trendline equation without drawing a graph?
I have a column that is missing about 30 data points, I'd like to fill the blanks based on a trendline of the existing data
Is it possible to generate a trendline equation without drawing a graph? I have a column that is missing about 30 data points, I'd like to fill the blanks based on a trendline of the existing data 


Excel's functions "FOR3ECAST" or "TREND" (using arrayformulae) will get you what you want assuming the trend is linear. By futzing with the data, you may be able to get a polynomial curve fitting . This taken from Excel Help: FORECAST FORECAST(x,known_y's,known_x's) Calculates, or predicts, a future value by using existing values. The predicted value is a yvalue for a given xvalue. The known values are existing xvalues and yvalues, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends. TREND TREND(known_y's,known_x's,new_x's,const) *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 yvalues along that line for the array of new_x's that you specify.* 

