Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
absolute reference | Excel Discussion (Misc queries) | |||
Absolute Reference | Excel Discussion (Misc queries) | |||
Absolute Reference | Excel Worksheet Functions | |||
absolute reference | Excel Discussion (Misc queries) | |||
absolute reference | Excel Discussion (Misc queries) |