Specific example of a redirection

R

Robert Peirce

'DATA'!B3 = "33"

'DATA'!B7 = "=INDEX(LINEST('ANNUAL DATA'!C3:C33,'ANNUAL DATA'!B3:B33),2)"
Several additional cells have almost exactly the same formula, just
referencing different columns.

I want to pickup the end of the columns, C and B and the others, by
referencing the contents of 'DATA'!B3. At this time, that row is 33.
Next year it will be 34, and so on.

I figured out how to use the INDIRECT() function in fairly simple
situations, but this one is eluding me.
 
B

Bob Greenblatt

'DATA'!B3 = "33"

'DATA'!B7 = "=INDEX(LINEST('ANNUAL DATA'!C3:C33,'ANNUAL DATA'!B3:B33),2)"
Several additional cells have almost exactly the same formula, just
referencing different columns.

I want to pickup the end of the columns, C and B and the others, by
referencing the contents of 'DATA'!B3. At this time, that row is 33.
Next year it will be 34, and so on.

I figured out how to use the INDIRECT() function in fairly simple
situations, but this one is eluding me.
Click to expand...
The formula in B7 should read:
=index(linest(indirect("'annual data'!c3:c"&data!b3),........

Hope this helps.
 
Top