Combination Permutation Excel Add-in

[sdruley]

I am looking for a good Excel Add-in that will assist me in the creation of a list of possible combinations but short of that let me explain what I need:

1) The letters D,E,F,G,H,I represent boolean variables. This expression is true if the product of each value (1 or 0) = 1. So this one is easy. It is true or false. No combinations list needed
2) Now we take away one of the letters and we have only 5. Now we have the following list of 5 letter combinations:

D E F G H
E F G H I
E F G H D
F G H I D
F G H I E
G H I D E
G H I D F
G H I E F
H I D E F
H I D F G
H I D E G
H I E F G

Okay, so far no software needed. Each of these expressions will either be true of false based on the products of their boolean components

3) Now we take away two letters and end up with this list of possible combinations that will resolve to either true of false. Still okay, no software needed

D E F G
D E F H
D E F I
D E G H
D E G I
D E H I
D F G H
D F G I
D F H I
D G H I
E F G H
E F G I
E F H I
F G H I

4) The last step is too hard to do. We take away three letters but now we need software to evaluate what this new list looks like, Some of the expressions might look like the following but I am sure this is the tip of the iceberg... at least I think it is.

D E F
D E G
D E H
D E I
D F H
D F G
D F I
D G I
D G H
D H I
E F G
E F H
E F I
E G H
E G I
E H I
F G H
F G I
F H I
G H I


Please disregard the following table. I couldn't delete it[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, width: 64, bgcolor: yellow"]E
[/TD]
[TD="class: xl68, width: 64, bgcolor: yellow"]F
[/TD]
[TD="class: xl69, width: 64, bgcolor: yellow"]G
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]E
[/TD]
[TD="class: xl68, bgcolor: yellow"]F
[/TD]
[TD="class: xl69, bgcolor: yellow"]H
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]H
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]H
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]H
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]D
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]H
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: yellow"]D
[/TD]
[TD="class: xl71, bgcolor: yellow"]G
[/TD]
[TD="class: xl71, bgcolor: yellow"]H
[/TD]
[TD="class: xl72, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: yellow"]E
[/TD]
[TD="class: xl68, bgcolor: yellow"]F
[/TD]
[TD="class: xl68, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]H
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]E
[/TD]
[TD="class: xl66, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]H
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: yellow"]F
[/TD]
[TD="class: xl66, bgcolor: yellow"]G
[/TD]
[TD="class: xl66, bgcolor: yellow"]H
[/TD]
[TD="class: xl67, bgcolor: yellow"]I
[/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

sdruley,

See if any of the following BOLD will assist you:

Myrna Larson, July 25, 2000, Microsoft.Public.Excel.Misc
http://www.mydatabasesupport.com/forums/spreadsheets/250560-combinations.html

Following is a macro based solution form Myrna Larson (Microsoft MVP) on permutation and combinations
1. It allows Combinations or Permutations.
2. The macro handles numbers, text strings, words (e.g. names of people) or symbols.
3. The combinations are written to a new sheet.
4. Results are returned almost instantaneously.
Setup:
In sheet1:
Cell A1, put "C" (Combinations) or "P" (Permutations).
Cell A2, put the number of items in the subset - in my case it's 3.
Cells A3 down, your list. - in my case (numbers from 1-5)


http://www.mrexcel.com/forum/newreply.php?do=newreply&noquote=1&p=2049347


Create list of all pair combinations

 

[sdruley]

hiker,

This information worked perfectly. Thank you

 

[hiker95]

sdruley,

Thanks for the feedback.

Which of the links did you finally pick?

You are very welcome. Glad I could help.

Come back anytime.

 

[sdruley]

Myrna Larson (Microsoft MVP)