Copying formulas

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

I understand how the copying of formulas works and how athe $ hepls to
maintain either the column or the row.

My question is can you reverse the procedure. Copying a formula to the right
will change the row number instead of the column number and copying down
will change the column.

Is this possible?
 
Here's an example:

=INDIRECT(CHAR(64+ROW(A1))&COLUMN(L1))

This is equivalent to =A12, but if you copy it across it will bring
values from A13, A14, A15 etc. If you copy it down it will bring
values from A12, B12, C12, D12 etc., but this will only work up to
column Z.

You can also look at the OFFSET function, and also TRANSPOSE.

Hope this helps.

Pete
 
Before someone does to a lot of trouble with this: why do you need it? Have
you looked at the TRANSPOSE function and/pr the Paste Special/Transpose
command?
best wishes
 
transpose did exacly what I needed. HTnk you.
Bernard Liengme said:
Before someone does to a lot of trouble with this: why do you need it?
Have you looked at the TRANSPOSE function and/pr the Paste
Special/Transpose command?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Click to expand...
 
I looked at transpose and that is what I needed. Thank you.
Here's an example:

=INDIRECT(CHAR(64+ROW(A1))&COLUMN(L1))

This is equivalent to =A12, but if you copy it across it will bring
values from A13, A14, A15 etc. If you copy it down it will bring
values from A12, B12, C12, D12 etc., but this will only work up to
column Z.

You can also look at the OFFSET function, and also TRANSPOSE.

Hope this helps.

Pete
 
Back
Top