array, range question

[Guest]

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

 

[Chip Pearson]

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)

 

[Guest]

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

 

[Jack Sons]

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

 

[Guest]

hi jack, that works as well, thank you