I found a forum about generating all possible permutations using a formula. I started using it then realized I needed combinations because the order doesn't matter and I don't want an excess amount of combinations. Here is a link to that permutations post if you were concerned: http://www.mrexcel.com/forum/excel-questions/654871-how-generate-all-possible-combinations-two-lists-without-macro.html So I need a new formula or way to filter out those rows that have the same values just in different orders. I need 9 columns with the amount to be chosen from each as follows: A:4 B:4 C:4 D:7 E:7 F:7 G:4 H:3 I:4 Another note- can't have duplications between columns B&C or D through F. This is a good combo: 0 (1 0) (0 1 2) 0 0 0 This is a bad combo: 0 (0 1) 7 6 5 0 0 0 This is a bad combo: 0 4 3 (2 0 1) 0 0 0

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel-Generating All Possible COMBINATIONS

ChallengerRT12

New Member

Oct 29, 2014

I found a forum about generating all possible permutations using a formula. I started using it then realized I needed combinations because the order doesn't matter and I don't want an excess amount of combinations. Here is a link to that permutations post if you were concerned:
http://www.mrexcel.com/forum/excel-...ble-combinations-two-lists-without-macro.html

So I need a new formula or way to filter out those rows that have the same values just in different orders. I need 9 columns with the amount to be chosen from each as follows:
A:4
B:4
C:4
D:7
E:7
F:7
G:4
H:3
I:4

Another note- can't have duplications between columns B&C or D through F.
This is a good combo: 0 (1 0) (0 1 2) 0 0 0
This is a bad combo: 0 (0 1) 7 6 5 0 0 0
This is a bad combo: 0 4 3 (2 0 1) 0 0 0