Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transpose with formulas
I have matrix of data (20 rows and 10 columns) and I want to transpose this
matrix. Up to this point it is easy but what makes it difficult is that the original matrix contains formulas in each individual cell and I want the original matrix and the transposed version of it to be linked to each other. In other words if a cell's value changes in the original matrix I want the corrosponding cell in the transposed matrix to take same value automatically. I tried to do this using absolye and relative references but it did not work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
transpose with formulas
"Kincal" wrote in message
... I have matrix of data (20 rows and 10 columns) and I want to transpose this matrix. Up to this point it is easy but what makes it difficult is that the original matrix contains formulas in each individual cell and I want the original matrix and the transposed version of it to be linked to each other. In other words if a cell's value changes in the original matrix I want the corrosponding cell in the transposed matrix to take same value automatically. I tried to do this using absolye and relative references but it did not work. If your first array is at (A1:J20), then select the range where you want your new array, say (A22:T21), then type in the formula =TRANSPOSE(A1:J20) enter it as an array formula by Control Shift Enter (which will give you curly braces). -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose and formulas | Excel Discussion (Misc queries) | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |