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
|