ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to union two array with same structure (https://www.excelbanter.com/excel-programming/313368-how-union-two-array-same-structure.html)

miao jie

how to union two array with same structure
 
maybe it's stupit question :)
but it's quite convenient for me in my case. anyone know how to union two
array which have same structure into one array.

for example:
array1 = ( (1,1),(1,2),(1,3))
array2 = ((2,1),(2,2))

I wanna get a new array like that
array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2))

thanks in advance :)

Alan Beban[_2_]

how to union two array with same structure
 
miao jie wrote:

maybe it's stupit question :)
but it's quite convenient for me in my case. anyone know how to union two
array which have same structure into one array.

for example:
array1 = ( (1,1),(1,2),(1,3))
array2 = ((2,1),(2,2))

I wanna get a new array like that
array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2))

thanks in advance :)

Are the arrays 0-based or 1-based (or something else)?

Are they 1-dimensional or 2-dimensional?

Alan Beban

Alan Beban[_2_]

how to union two array with same structure
 
miao jie wrote:

maybe it's stupit question :)
but it's quite convenient for me in my case. anyone know how to union two
array which have same structure into one array.

for example:
array1 = ( (1,1),(1,2),(1,3))
array2 = ((2,1),(2,2))

I wanna get a new array like that
array3 = ( (1,1),(1,2),(1,3),(2,1),(2,2))

thanks in advance :)


If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

Array3 = MakeArray(Array1, Array2,1) to give a 1-based Array3;
Array3 = MakeArray(Array1, Array2,0) to give a 0-based Array3

Alan Beban


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com