Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default From a series to a matrix

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
from a series to a matrix using formula Moohwan Excel Discussion (Misc queries) 2 April 13th 09 08:07 PM
From a series to a matrix Rick Rothstein Excel Programming 0 April 13th 09 06:35 PM
problem when creating a series of matrix [email protected] Excel Programming 9 January 9th 09 08:28 PM
How can I transpose nXm matrix to mXn Matrix MIHir Excel Worksheet Functions 2 August 9th 08 11:44 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"