Copying relative cell references

[Arts Lost]

Using 2003.

When I drag, using cell references, they do not function as described
$b$1 copies as should (yields B1 down the range)
b$1 copies as should (yields B2, B3, B4...)
$b1 copies the same as b$1 (yields B2,B3,B4 and not C1, D1, E1....)

because I want to keep the row constant and change the column during the
drag this is a problem. Any suggestions?

 

[Arvi Laanemets]

Hi

From what you told, I see that $B1 copies row-wise as it should ($B2, $B3,
etc.), but are you sure about B$1 ? It must copie column-wise as C$1, D$1
etc.

To be more clear, an example for all 4 possible variants:
1.
=A1 =B1 =C1
=A2 =B2 =C2
=A3 =B3 =C3

2.
=$A1 =$A1 =$A1
=$A2 =$A2 =$A2
=$A3 =$A3 =$A3

3.
=A$1 =B$1 =C$1
=A$1 =B$1 =C$1
=A$1 =B$1 =C$1

4.
=A$1 =A$1 =A$1
=A$1 =A$1 =A$1
=A$1 =A$1 =A$1


Arvi Laanemets

 

[RagDyeR]

When you say "down the range", I assume you mean down a column, *not* across
a row.

I ask this, because what you said here is *not* correct:
<<"b$1 copies as should (yields B2, B3, B4...)">>

B$1 copied down a column yields B$!, B$1, B$1, ... etc.
B$! copied across a row yields C$1, D$!, E$!, ... etc.


This is also *incorrect*:
<"$b1 copies the same as b$1 (yields B2,B3,B4 and not C1, D1, E1....)>"

So, I assume you have some typo's.

Guessing that you want to drag *down*, and increment the column *only*, try
this:

=OFFSET($B$1,,ROW(A1)-1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Using 2003.

When I drag, using cell references, they do not function as described
$b$1 copies as should (yields B1 down the range)
b$1 copies as should (yields B2, B3, B4...)
$b1 copies the same as b$1 (yields B2,B3,B4 and not C1, D1, E1....)

because I want to keep the row constant and change the column during the
drag this is a problem. Any suggestions?

 

[Arts Lost]

Thanks for showing me the error of my ways... you are of course absolutely
correct and you have fixed what has been a perplexing problem
(misunderstanding on my part). I'm rushiing right out to try the offset
solution.

Thanks again.
Art

 

[Arts Lost]

Arvi
Thank you... I discovered from your examples that I need to be dragging
across the row in order to accomplish my goal NOT down the column.