G
Guest
is there way to list values in an array or range, in a column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
G
Guest
dear chip, that's awesome stuff(!), many thanks
J
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
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
G
Guest
hi jack, that works as well, thank you