Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert column to array?
Some of the discussion on unique integers made me try to think
of a method to convert a column to an array. I could not come up with any easy method. A Google search produced http://www.cpearson.com/excel/excelF.htm , where there was a VBA method to do the reverse: convert an array to a column. I suppose I could adapt the method for what I want but, not wanting to reinvent the wheel, has anyone any good suggestions? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert column to array?
James,
what do you mean exactly? Generating an array constant from a range? Or take a 1-dimensional array and create a 2-dimensional from this? HTH Kostis Vezerides On Jan 26, 7:42 pm, "James Silverton" wrote: Some of the discussion on unique integers made me try to think of a method to convert a column to an array. I could not come up with any easy method. A Google search producedhttp://www.cpearson.com/excel/excelF.htm, where there was a VBA method to do the reverse: convert an array to a column. I suppose I could adapt the method for what I want but, not wanting to reinvent the wheel, has anyone any good suggestions? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert column to array?
"vezerid" wrote in message
ps.com... James, what do you mean exactly? Generating an array constant from a range? Or take a 1-dimensional array and create a 2-dimensional from this? HTH Kostis Vezerides Thanks for the quick feed-back! It's the latter; I was using column and 1-d array as synonyms. -- James Silverton Potomac, Maryland |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert column to array?
OK then, say your 1D is in A1:A12, and also say that you want to
produce a 4row-3col output. We are interested in the number 3. If your 2D starts at C1 then use the following formula: =INDEX($A$1:$A$12,(ROW()-ROW($C$1))*3+COLUMN()-COLUMN($C$1)+1) HTH Kostis On Jan 26, 8:05 pm, "James Silverton" wrote: "vezerid" wrote in glegroups.com... James, what do you mean exactly? Generating an array constant from a range? Or take a 1-dimensional array and create a 2-dimensional from this? HTH Kostis VezeridesThanks for the quick feed-back! It's the latter; I was using column and 1-d array as synonyms. -- James Silverton Potomac, Maryland |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert column to array?
Hello, vezerid!
You wrote on 26 Jan 2007 09:22:38 -0800: v =INDEX($A$1:$A$12,(ROW()-ROW($C$1))*3+COLUMN()-COLUMN($C$1)+ v 1) v HTH v Kostis Thanks very much Kostis! That does the job smoothly for a 3 column array. I had a suspicion that INDEX might be involved but I was not very familiar with the function. Incidentally, the method can readily be adapted for producing an array of unique integers as was asked earlier by someone else since producing a column of unique integers is easy. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |