Re : Excel Formulation of 2-Dimensional Array

1. Look at the formula, =COLUMN(INDIRECT("A:O")) ; It produces a
horizontal (1-dimensional) array :
{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}. That looks nice.

2. And now, the question is, How is it possible to devise a formula to
give rise to a 2-dimensional (3-row x 5-column) array such as :
{1,2,3,4,5;6,7,8,9,10;11,12,13,14,15} ?

3. Please share your experience.

4. Regards.

Try this:
=(ROW(1:3)-1)*5+COLUMN(A:E)
(NOTE: don't think the INDIRECT is necessary since the result is independent
of the actual addresses)

" wrote:

Re : Excel Formulation of 2-Dimensional Array

1. Look at the formula, =COLUMN(INDIRECT("A:O")) ; It produces a
horizontal (1-dimensional) array :
{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}. That looks nice.

2. And now, the question is, How is it possible to devise a formula to
give rise to a 2-dimensional (3-row x 5-column) array such as :
{1,2,3,4,5;6,7,8,9,10;11,12,13,14,15} ?

3. Please share your experience.

4. Regards.