Create Combinations and permutations from 27 numbers

**theborg** · 07-15-2012, 02:48 AM

Hi Im new to this forum,
I have been away from using VBA for a number of years so not used to 2010 version. I was hoping not to ask this but browsing through the answers to a similar questions are close but not quite there. Anyway I have 27 numbers 1 - 27. And I need help to make a macro that can list in rows of 6 columns 4 number permutations (Single n0 in each cell) 6 numbers = 15 x 4 n0 perms, no 4 number permutation in any of the next rows are to duplicate any previous row. From my calcs there should be 17550 perms of 4 in turn 1170 rows of 6 n0s. Can any 1 guide me in writing this macro.. Any help will be much appreciated..
Kind regards
theborg

**shg** · 07-15-2012, 01:31 PM

There are 17550 combinations of 27 choose 4. Why do you want them in six columns rather than four? How do you get 1170 rows out of that?

**xladept** · 07-15-2012, 01:51 PM

Are you listing the permutations then???

**theborg** · 07-18-2012, 02:28 AM

Gladstone darts club.xlsx

Hi ghd and xldept,
Sorry for the confusion. But I am trying to formulate a draw for our darts club. Instead of names im using numbers up to 24 "not 27" members. the objective is to select 4 teams of 6 on a weekly basis where no more than 4 people in the 6 do not play together again over a period of weeks or a cycle. So by using numbers i have produced a table of all combinations about 80k .I have posted a sample of what i wish to be done... any help will be appreciated....the borg.