formula to find all possible combinations

G

Guest

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?
 
D

D Hilberg

The formula to *count* the combinations:

= 2^7 - 1

If you want the whole list, you may need a macro.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF INDEX and MATCH function together 7
Generating Possible Combinations and Assigning ID Number 1
Hide a row based on one textbox 6
number combinations. 2
Updating rows - Excel Formula or Something Else? 2
VBA to run all variable combinations in a calculation model and store result 6
How can I find all possible combinations of words? 4
List 6-of-36 combinations matching 4 (errata) 1

Top