Captain Snuggles wrote:
Here's what I want to do. I have 6 numbers (1, 2, 3, 4, 5 and 6) and I
need to break these six numbers into sets of 3 so that each number is
grouped with 2 other unique numbers with no repeat numbers. So, you
can't pair 1,1,1 or 1,12, each number has to be unique. There should
be 120 different sets of numbers, but I can't find a macro or formula
to do this. Any ideas?
Ideally I'd like it to look like this:
1,2,3
1,2,4
1,2,5
1,2,6
1,3,4
1,3,5...and so on.

Another play to tinker with ..

Here's a link to a sample book with Myrna Larson's sub implemented:
http://savefile.com/files/1635536
MyrnaLarson_Combination_Permutation.xls

In Sheet1, just make the settings as:

Put in A1: P
Put in A2: 3

List the 6 items in A3:A8, viz. in this instance,
list the 6 numbers: 1,2,3,4,5,6

Then select A1, and click the button "ListPermutations"

The 120 permutations of 3 from 6 [i.e.: =PERMUT(6,3)]
will be listed in a new sheet to the left
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---