Dynamic Range Name in Functions
 

Hi -

I have a column range of cells from G4:G103 where the number of values
changes. It will always start at G4 but may end anywhere within the range. I
am manipulating a couple of charts with this data so I have a count formula
and I clear all cells without a value in the range. Everything is working
great except the trend line formula's.

I am trying to calculate the X,Y & R2 in a power trend line. Thanks to Mike,
I have all the formula's working correctly now as long as I put in a range.
But what I would like to do is put in a dynamic range name, as stated above,
to get the X,Y & R2 formulas to change as well. I can't seem to get it to
work.

My Dynamic range is "ChartRepairs" =OFFSET(Learning Curve!$G$4,0,0,COUNTA
(Learning Curve!$G$4:$G$103),1)

As an example of one of the trend formulas, my X formula is =INDEX(LINEST(LN
(G4:G16),LN($E4:$E16)),1)

When I try =INDEX(LINEST(LN(ChartRepairs),LN($E4:$E16)),1) I get an error of
#Name? E4:E16 also has a named dynamic range which I add but for this example
I have not included it.

Can anyone see what I am doing wrong?

--
Message posted via http://www.officekb.com