Array Functions - how big?

[Patrick Molloy]

Here's an interesting question ( from my boss!)
We have to populate a region from an array function that
returns a varied number of rows and columns.
We need to know the return size so as to avoid missing
data if our range is too small, and to avoid #NA if our
range is too large.

We have discovered that an array fornmula will reveal the
total number of items
eg
{=COUNT(test())}
returns 18 if test() returns a 3x6 array
How would we find the size is 3 x 6 ?

Patrick Molloy

 

[Harlan Grove]

...
...

We have discovered that an array fornmula will reveal the
total number of items
eg
{=COUNT(test())}

Shouldn't that be COUNTA rather than COUNT, or does test() always return
numbers?

returns 18 if test() returns a 3x6 array
How would we find the size is 3 x 6 ?

ROWS(test()) and COLUMNS(test()) work for me. Not for you? Granted this requires
redundant test() calls.