from a series to a matrix using formula
 

Hi.
Suppose I have a series of observations.
1
3
5
7
9

My objective is that I want to have the following matrix.
1 3 5
3 5 7
5 7 9

How could I accomplish this work?
Any help would be appreciated.
thanks a lot in advance.

from a series to a matrix using formula
 

Easy. In B1 thru D3 enter:

=A1 =A2 =A3
=A2 =A3 =A4
=A3 =A4 =A5

--
Gary''s Student - gsnu2007L


"Moohwan" wrote:

Hi.
Suppose I have a series of observations.
1
3
5
7
9

My objective is that I want to have the following matrix.
1 3 5
3 5 7
5 7 9

How could I accomplish this work?
Any help would be appreciated.
thanks a lot in advance.

from a series to a matrix using formula
 

Enter this in B1
=INDIRECT("A"&(IF(MOD(ROW(),3)=0,3+COLUMN()-2,MOD(ROW(),3) + COLUMN()-2 )))
and copy to B1:D3

You can change 3 to n and copy to nxn cells starting at B1... and having the
required number of row filled in Col A

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Moohwan" wrote:

Hi.
Suppose I have a series of observations.
1
3
5
7
9

My objective is that I want to have the following matrix.
1 3 5
3 5 7
5 7 9

How could I accomplish this work?
Any help would be appreciated.
thanks a lot in advance.