View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel Formulation of 2-Dimensional Array

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.