absolute reference
 

when using an absolute refrence say a$1 , is it possible to have the a
change to b c d e ect when pasting the formula down the col rather than
accross the row,

im aware that by pasting accross the A would auto move but with the current
set up it dosnt move when pasting down the col

absolute reference
 

check indirect()
=indirect("R1C"&row()-cf,0)
(Cf is the correction factor to get the row()-1 to equal 1 (or whatever
column you want to start ) based on the row you start the equations.

"Rich" wrote:

when using an absolute refrence say a$1 , is it possible to have the a
change to b c d e ect when pasting the formula down the col rather than
accross the row,

im aware that by pasting accross the A would auto move but with the current
set up it dosnt move when pasting down the col

absolute reference
 

=INDEX($1:$1,ROWS($1:1)) entered in A2 and copied down will return A1, B1, C1
etc. values.


Gord Dibben MS Excel MVP

On Wed, 15 Aug 2007 04:24:01 -0700, Rich (no spam) wrote:

when using an absolute refrence say a$1 , is it possible to have the a
change to b c d e ect when pasting the formula down the col rather than
accross the row,

im aware that by pasting accross the A would auto move but with the current
set up it dosnt move when pasting down the col