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 |