Re : Excel Formulation of 2-Dimensional Array

T

tkt_tang

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

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re : Excel Sorting a 2-Dimensional Array 11
2 dimensional array 3
Multi-Dimensional Array Procedures 2
Excel Array Conversion from 2-Dimensional to One 4
Declaring Multi-Dimensional Arrays 5
2 dimensional array (variant) 9
Multi Dimensional Array 11
Using Excel statistical functions on a subset of an array 2

Top