Thread: Keeping the column constant in a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Keeping the column constant in a formula
One way ..

In A6:
=INDEX($A$1:$A$5,COLUMN(A1))
Copy A6 across to E6
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arithmetic functions with embedded text" wrote:
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?




Reply With QuoteReply With Quote