Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing Columns in a Row. PLEASE HELP!!
Is there any way to get Excel to increment DOWN a COLUMN when applying a
common function/equation HORRIZONTALLY across a ROW? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
can't insert columns between columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |