View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default 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