| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to find all possible combinations
Hello,
Is there something in Excel 2003 to find all possible combinations of a set. For example if I have: Employee Spouse Domestic Partner Child Children DP Child DP Children How do I find all the possible combinations? Like: Employee only is one combination Employee + Spouse is one combination Employee + Spouse + Child is one combination Please let me know if this is possible? -- Thank You! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to find all possible combinations
The formula to *count* the combinations:
= 2^7 - 1 If you want the whole list, you may need a macro. On Jul 12, 12:02 pm, maijiuli wrote: Hello, Is there something in Excel 2003 to find all possible combinations of a set. For example if I have: Employee Spouse Domestic Partner Child Children DP Child DP Children How do I find all the possible combinations? Like: Employee only is one combination Employee + Spouse is one combination Employee + Spouse + Child is one combination Please let me know if this is possible? -- Thank You! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to find all possible combinations
Thanks for the formula D Hilberg. That's a start.
Does anyone know somewhere on the web where I can research to create this macro? I do not mind to create the macro myself with a little push in the right direction. -- Thank You! "D Hilberg" wrote: The formula to *count* the combinations: = 2^7 - 1 If you want the whole list, you may need a macro. On Jul 12, 12:02 pm, maijiuli wrote: Hello, Is there something in Excel 2003 to find all possible combinations of a set. For example if I have: Employee Spouse Domestic Partner Child Children DP Child DP Children How do I find all the possible combinations? Like: Employee only is one combination Employee + Spouse is one combination Employee + Spouse + Child is one combination Please let me know if this is possible? -- Thank You! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i find all possible combinations | Excel Discussion (Misc queries) | |||
| getting combinations | New Users to Excel | |||
| find all combinations of cells that add up to certain number | Excel Worksheet Functions | |||
| find all combinations of cells that add up to certain number | Excel Discussion (Misc queries) | |||
| Find combinations of numbers to equal a value | Excel Worksheet Functions | |||
Linear Mode
