Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose cell references
I have a comparison of 5 solutions on different parameters.
I have my solutions listed in rows with all the parameters in columns. There are many parameters, so I exceed my page width. For display I want to show the values with the 5 solutions as columns, and then all the parameters as rows. I have the data in cells like A5 A6 A7 A8 A9 now I want that listed in cells A10 A11 A12 A13 A14 i.e. in A10 I want "=A5", A11 "=A6" etc. My question is: Can I somehow easily make these references to the cells in the original listing - e.g. by dragging the window handle or similar... (when I do that I get "=A5" "=B5" "= C6" etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose cell references
Put this formula in A10:
=INDIRECT("A"&COLUMN(E1)) then just copy it across into B10:E10. Hope this helps. Pete On Feb 15, 12:52*pm, RSunday wrote: I have a comparison of 5 solutions on different parameters. I have my solutions listed in rows with all the parameters in columns. There are many parameters, so I exceed my page width. For display I want to show the values with the 5 solutions as columns, and then all the parameters as rows. I have the data in cells like A5 A6 A7 A8 A9 now I want that listed in cells A10 A11 A12 A13 A14 i.e. in A10 I want "=A5", A11 "=A6" etc. My question is: Can I somehow easily make these references to the cells in the original listing - e.g. by dragging the window handle or similar... (when I do that I get "=A5" "=B5" "= C6" etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Transpose Reletive Cell References? | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Transpose-relative cell references would be useful. | Excel Worksheet Functions |