Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Would appreciate any help to generate a list using excel that take two array to generate a permuation list that "maintain sequence" within the Array. For e.g Array1 = A,B,C,D,E Array2 = 1,2,3,4,5 Some of the valid ouputs will be A,B,C,D,E,1,2,3,4,5 A,1,2,B,3,C,D,E,4,5 A,B,C,1,2,3,4,D,5,E In the above, the sequence of elements in Array1 and Array2 is maintained. A,B,1,C,D,3,E,2,4,5 is not a valid permuation as sequence for Array2 is not maintained. Any pointers to generate such list also will be appreciated. Thanks Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generating a list | Excel Worksheet Functions | |||
Generating a list | Excel Worksheet Functions | |||
Generating list | Excel Worksheet Functions | |||
Problem generating list | Excel Discussion (Misc queries) | |||
list generating | Excel Worksheet Functions |