Referencing Columns in a Row. PLEASE HELP!!

  • Thread starter Chism Henry via OfficeKB.com
  • Start date
C

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?
 
D

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.
 
R

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!
==============================================
 
Top