Referencing Columns in a Row. PLEASE HELP!!

[Chism Henry via OfficeKB.com]

Is there any way to get Excel to increment DOWN a COLUMN when applying a
common function/equation HORRIZONTALLY across a ROW?

 

[Damon Longworth]

You can use the Offset function along with the Column function:

=OFFSET($A$1,COLUMN(A1)-1,0)

This will increment down column A when it is copied across a column.

 

[RagDyer]

Another way, without being volatile:

=INDEX($A:$A,COLUMN(A:A))
--
HTH,

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