Matrix
Hello,
=INDEX(1:65536,COLUMN(),ROW())
Fill either the diagonal and the upper right triangle or the diagonal
and the lower left triangle of your matrix and put above formula into
all other cells. Replace 1:65536 by your matrix' range or its range
name if necessary.
Regards,
Bernd
|