Thread: Matrix
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Matrix

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