HELP: how to reference across columns while copying down

[aaa27aaa]

Hello,

Thanks for any input. I can't seem to figure out how to referenc
across columns while copying down rows. Please help! I've figured ou
how to reference down rows while copying across column
[=INDIRECT(ADDRESS(COLUMN()x,x))] but not vice versa. Thanks

 

[Ken Wright]

Try looking at OFFSET and then use the ROW() function in the Column argument of
the OFFSET function. As you copy down the ROW() function will return an
increasingly higher number, and will then pass this as the column argument
incrementing by one column each time.

=OFFSET($A$1,,ROW())

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Hello,

Thanks for any input. I can't seem to figure out how to reference
across columns while copying down rows. Please help! I've figured out
how to reference down rows while copying across columns
[=INDIRECT(ADDRESS(COLUMN()x,x))] but not vice versa. Thanks!