Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |