Thread: Matrix
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default 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