absolute reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
=INDEX($1:$1,ROWS($1:1)) entered in A2 and copied down will return A1, B1, C1
etc. values.


Gord Dibben MS Excel MVP
 
Back
Top