Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
permutation of values in 2 dimensional array
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutli-dimensional Array to Single-Dimension Array | Excel Programming | |||
3 dimensional array | Excel Programming | |||
Create One-Dimensional Array from Two-Dimensional Array | Excel Programming | |||
Creating a Combination or Permutation Array in Excel | Excel Programming | |||
Do I need a two dimensional array for this? | Excel Programming |