Formula Transpose

S

snax500

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
 
M

Morrigan

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

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.

Thank
Click to expand...
 
M

MrShorty

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

Michael

Could you give a little more information - what are you trying to accomplish?
What are the formulas?
 
Top