"Manfred" wrote :
Your example seems to work, but when I insert a row
at 1 or a column at F, the 3x7 array goes kaputt.

Slightly more robust (but still not foolproof) ..

Define the range G1:G20 as: VertC (say)

Then put instead in J2:
=IF(ISERROR(INDEX(VertC,ROWS($A$1:A1)*7-7+COLUMNS($AA$1:AA1))),"",INDEX(Vert
C,ROWS($A$1:A1)*7-7+COLUMNS($AA$1:AA1))
and copy J2 across/fill down to P4, as before

Anyway, I was looking to create the 3x7 array without
creating the 15x1 array first.

I'm not sure if this is possible, and with "insert row/column-proofing"
thrown in as well <g. Let's hang around awhile for possible insights from
others.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---