B
bashir.zain
Hi guys,
I have a 2 dimensional array, Positions(x,y), which has a variable
number of rows(x) and columns(y):
e.g. 4 5 3 4
500 500 800 100
450 450 750 50
400 400 700 0
350 350 -50
300
I know the number of columns and the number of rows in each column
(stored in header of column).
How can i obtain permutations of all values in each column.... i.e.
500 500 800 100
500 500 800 50
500 500 800 0
500 500 800 -50
500 500 750 100
.....
.....
.....
350 300 700 0
350 300 700 -50
I am using VBA and outputting the values to fields in excel.
I have a 2 dimensional array, Positions(x,y), which has a variable
number of rows(x) and columns(y):
e.g. 4 5 3 4
500 500 800 100
450 450 750 50
400 400 700 0
350 350 -50
300
I know the number of columns and the number of rows in each column
(stored in header of column).
How can i obtain permutations of all values in each column.... i.e.
500 500 800 100
500 500 800 50
500 500 800 0
500 500 800 -50
500 500 750 100
.....
.....
.....
350 300 700 0
350 300 700 -50
I am using VBA and outputting the values to fields in excel.