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

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" <(E-Mail Removed)> wrote in message
news:70E62D6D-A526-41A7-AA1C-(E-Mail Removed)...
> is there way to list values in an array or range, in a column?

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 .
>

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" <(E-Mail Removed)> schreef in bericht
news:F17E82A9-2077-444A-BAAA-(E-Mail Removed)...
> 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 .
>>
>

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.
>