Function to return 2 arrays as output

Please Login or Register  to view this content.

In Excel Cell

=Arrays1_2(1)

Or

=Arrays1_2(2)

Or

For auto increment try this...

=Arrays1_2(ROWS($1:1))

Drag it down...

A function can't return two separate arrays. You can either return a 2D array, or you can pass one (or both) of the output arrays to the routine so that it can alter the passed variable directly.

A function can return two arrays, by using a ByRef argument.

Please Login or Register  to view this content.

Hello Kyle/mikerickson,

Thanks for answer. I've tried both solutions and I've been able to adapt mike's solution but not Kyle´s solution.

For Kyle's solution I have issues assigning the values to the arrays within the function and for mike's solution, it seems to work
fine, but the numbers are stored as string, I'm not sure why. I'm modified I little bit your codes since the input of the function is
a variant array of n x m dimensions.

This is what I've done:
Kyle´s solution: (I get wrong number of dimensions inside the function)

Please Login or Register  to view this content.

mikerickson´s solution:

Please Login or Register  to view this content.

Thanks again for the help

I'm glad you've got it to work.
There's one more tweek you might want. If you are returning the array to a worksheet formula, you could add an Index argument to specify which array you want returned.

Please Login or Register  to view this content.