Keeping the column constant in a formula

[Guest]

I am trying to drag a formula in a row while keeping the source column
constant and incrementing the column number...

A B C
1 1.1
2 2.2
3 3.3
4 4.4
5
6 =A1 =A2 =A3.....

I know how to use the $ to keep the row from changing, but how do you keep
the comlumn constant?

 

[PCLIVE]

You do it the same exact way.

A$1 will keep the row constant.
$A1 will keep the column constant.
$A$1 will keep both the row and column constant.

HTH,
Paul

"Arithmetic functions with embedded text"

 

[Guest]

One way ..

In A6:
=INDEX($A$1:$A$5,COLUMN(A1))
Copy A6 across to E6

 

[Guest]

When I use the $ in front of the column, $A1, and drag it across a row, both
the row and the column are kept constant

 

[PCLIVE]

That is because you are dragging it across which means you are still in same
row. Are you saying that when you drag across, you'd like the Row number to
increment?


"Arithmetic functions with embedded text"