Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy matrix (diagonal)
Dear all, Does anyone know how to copy a diagonal matrix into one column. Example: 1 2 3 5 5 3 4 7 7 8 9 4 4 10 8 11 into 1 3 9 11 Any help would be appreciated. Thanks, Mu -- Mu ----------------------------------------------------------------------- Mut's Profile: http://www.excelforum.com/member.php...fo&userid=3063 View this thread: http://www.excelforum.com/showthread.php?threadid=54317 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy matrix (diagonal)
Hi,
supposing, your matrix is in cells a1:d4, you can insert formula into e1: =OFFSET($A$1,ROW()-1,ROW()-1) and copy down to d4. Regards, Ivan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy matrix (diagonal)
Thanks Ivan! It works.. :) -- Mut ------------------------------------------------------------------------ Mut's Profile: http://www.excelforum.com/member.php...o&userid=30633 View this thread: http://www.excelforum.com/showthread...hreadid=543178 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Diagonal header row | Excel Discussion (Misc queries) | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
How do I get the diagonal of a matrix from excel? | Excel Worksheet Functions | |||
text diagonal | Excel Discussion (Misc queries) | |||
show a set of diagonal values in a matrix as a set of consecutive. | Excel Worksheet Functions |