array, range question
 

is there way to list values in an array or range, in a column?

array, range question
 

See my Arrays To Columns page at http://www.cpearson.com/excel/arr2col.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"mwam423" wrote in message
...
is there way to list values in an array or range, in a column?

array, range question
 

dear chip, that's awesome stuff(!), many thanks

"Chip Pearson" wrote:

See my Arrays To Columns page at http://www.cpearson.com/excel/arr2col.htm .

array, range question
 

Years ago I got this from Alan Beban:

the following seems to work for a range named "rng1"; just enter it in a
cell and fill down.

=INDEX(rng1,ROW(A1)-MOD(ROW(A1)-1,COLUMNS(rng1))-((COLUMNS(rng1)-1)*(ROW(A1)-MOD(ROW(A1)-1,COLUMNS(rng1)))-(COLUMNS(rng1)-1))/COLUMNS(rng1),MOD(ROW(A1)-1,COLUMNS(rng1))+1)

Works like a charm.


Jack Sons
The Netherlands

"mwam423" schreef in bericht
...
dear chip, that's awesome stuff(!), many thanks

"Chip Pearson" wrote:

See my Arrays To Columns page at
http://www.cpearson.com/excel/arr2col.htm .

array, range question
 

hi jack, that works as well, thank you

"Jack Sons" wrote:

Years ago I got this from Alan Beban:

the following seems to work for a range named "rng1"; just enter it in a
cell and fill down.