HELP: how to reference across columns while copying down

  • Thread starter Thread starter aaa27aaa
  • Start date Start date
A

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
 
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 :-)
----------------------------------------------------------------------------



aaa27aaa > said:
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!
Click to expand...
 
Back
Top