Another way, without being volatile:

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

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



"Damon Longworth" wrote in message
...
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.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
www.ExcelUserConference.com


"Chism Henry via OfficeKB.com" wrote in message
...
Is there any way to get Excel to increment DOWN a COLUMN when applying a
common function/equation HORRIZONTALLY across a ROW?