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. |
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 |