Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel combinations from groups
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 | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |