| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
| Creating a formula to return a particular result from a Matrix Tab | Excel Discussion (Misc queries) | |||
| How to od a combined IF and AND in a matrix formula | Excel Worksheet Functions | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
| entering matrix formula | Excel Worksheet Functions | |||
Hybrid Mode
