Formula Transpose
 

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks

Select A1:C1 and copy

Select A2

EditPastespecial and click Transpose

--
HTH

Bob Phillips

"snax500" wrote in message
oups.com...
In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks

Thanks for the reply but I wanted a formula that I can use not just
copy paste.

A2 = OFFSET(A1,2-ROW(),ROW()-2)


snax500 Wrote:
In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=389369

How about the TRANSPOSE function? It's an array function, but it does
exactly what you want.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=389369

Could you give a little more information - what are you trying to accomplish?
What are the formulas?
--
Sincerely, Michael Colvin


"snax500" wrote:

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks

Thanks Morrigan, your formula is exactly what I am looking for.

Michael wrote:
Could you give a little more information - what are you trying to accomplish?
What are the formulas?
--
Sincerely, Michael Colvin


"snax500" wrote:

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks