Combination Generator

Good afternoon,

Could someone please point me in the right direction for a combination generator.

I have 4 items in each subset, populated numerically 1-3

The problem I am facing with other combination generators is that they do not duplicate values, and therefore do not work at all because there are three possibilities and 4 spaces to fill.

So I am looking for every conceivable result.

Myrna Larson produced a combination/Permutation Generator, but I do not understand enough to edit it to allow duplicates.

Could someone please help me.

I have included the code for Myrna Larson's generator below.

Please Login or Register  to view this content.

Hi,

must be precise !

Need uniques combinations or permutations ? 'cause not the same …

Hi Marc,

a non unique combination with 4 values in each subset with the values ranging from 1-3

Eg.

1,2,3,3
1,1,1,1
2,2,2,2
3,3,3,3
1,1,2,2
2,2,1,1
2,1,1,2
1,3,3,1
3,1,2,1
2,1,3,1

It's permutations then …

I don't understand your issue with the code but you'll find many examples on web …

Hi Marc,

How do you figure that?

Permutations only allow you to rearrange a string of values into a different order. Which is the complete opposite of what I am looking to do.

In order to get around the combination not handling duplicates, I used variables 1-12 where:

1=4=7=10
2=5=8=11
3=6=9=12

And then replacing the figures as above back to the 1-3 and then using a countif to remove any duplicates.

My bad, it's combinations with duplicate items …