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

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

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