Thread
:
copy matrix (diagonal)
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ivan Raiminius
external usenet poster
Posts: 258
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
Reply With Quote
Ivan Raiminius
View Public Profile
Find all posts by Ivan Raiminius