Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate table of combinations
Can anyone point me to an algorithm or VBA code to produce a table of
combination of items. For example if the items are 1,2,3,4,5 then the code would generate: 1 1, 2 1, 2, 3 1, 2, 3, 4 1, 2, 3, 5 1, 2, 3, 4, 5 1, 2, 4 1, 2, 4, 5 1, 2, 5 1, 3 1, 3, 4 1, 3, 4, 5 1, 3, 5 1, 4 1, 4, 5 1, 5 2 2, 3 2, 3, 4 2, 3, 4, 5 2, 3, 5 2, 4 2, 4, 5 2, 5 3 3, 4 3, 4, 5 3, 5 4 4, 5 5 Similar for dog, cat, house -- Gary's Student |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column | Excel Discussion (Misc queries) | |||
How to generate a list from a table | Excel Discussion (Misc queries) | |||
Sorting of a pivot table by outer and inner row field combinations | Excel Discussion (Misc queries) | |||
Generate Random Number Table | Excel Programming | |||
Generate all possible combinations from three data sets? | Excel Programming |