Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
I need a formula that will sum the top 3 number in a column | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Formula to reference column heading | Excel Worksheet Functions |