Matrix

S

Sandy

I have a matrix and I would like to copy the info from the columns to the rows.

a1 b1 c1 d1 e1
a2 1 2 3 4
a3 2 3 4 5
a4 3 4 5 6
a5 4 5 6 7

Since a3 and d1 equal the same number and a4 and 31 equal the same number
and so on and so on. how can I auto fill the formula to fill across the row.
My formula is:

c1 =a3 d1 =a4 e1 =a5
 
B

Bernd P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top