column to row in formula
I am trying to reference the data in a column but use it in a row. ie
I have data in a column 'A' as follows:
w
x
y
z
I want to write a formula in cell A10 as follows:
=$A1 (result = w)
When I copy the formula to cell B10 I want the result to = x (ie $A2)
I know how to copy a complete column and then transpose it but I was
wondering if I could accomplish it in a formula.
Thanks in advance
E
|