Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combinations from group in Excel
I have the following problem with excel.
I have a varied amount of groups of names and each group contains a different amount of names. I need excel to list all the possible combinations from each group. The combination size also varies. EG Group 1 Group 2 Group 3 Dave Fred Janet Harry Bob Selina Jim jane Jo The group sizes vary and the amount of group vary. I need excel to make various combinations eg In a "2" combination Dave can go with Fred or Janet. Fred can go with Janet ETC ETC Hope I haved explained this well enough |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel to Calculate All Combinations of a Set of Data? | Excel Worksheet Functions | |||
Can excel list combinations | Excel Worksheet Functions | |||
Can excel list the possible combinations from a range of cells | Excel Worksheet Functions | |||
Excel combinations from groups | Excel Discussion (Misc queries) | |||
Generating excel combinations | Excel Discussion (Misc queries) |