Trendline equation help

I am looking to make a trendline equation [=TREND()] which takes into account at max 25 x's and 25 y's. HOWEVER, I want it to be able to ignore blank cells since I plan on using this excel worksheet as a template for a linked word document. This way, I dont have to constantly change the parameters of the trend line when I have less than 25 coordinates to plot...

Thanks in advance!

Hi

Try this, using sheet1.
A1: X Vals
A2:A20: 1,2,3,....18, 19
B1: Y Vals
B2:B6: some random numbers
Formulas, Name Manager, New, Name: yvals, refers to: =OFFSET(Sheet1!$B$2,0,0,COUNT(Sheet1!$B$2:$B$26),1)
Formulas, Name Manager, New, Name: xvals, refers to: =OFFSET(yvals,0,-1)
C1: TREND
C2: =IF(B2,B2,IF(A2,TREND(yvals,xvals,A2),"")) Copy from C2 to C26.

As you have a fixed range, then if you have data in column B (the y vals) then the named range will automatically update to cover both the x and y data ranges. If you don't have any x value going all the way forward, then it will only produce a trend for those values of x.

HTH

rylo