combinations

  • Thread starter Thread starter Jack Sons
  • Start date Start date
J

Jack Sons

Hi all,

I would like to generate all possible combinations (not permutations, so one
combination of 6 out of the set abcdefg will also be aaaaab etc) of p out
of n characters, n say from 3 to 8 and p from 3 to n. The character set
could contain (in principle) any character that can be obtained by alt plus
0 plus 3 numbers of the numerical keyboard (alt 0233 = é etc.).

The elements of each combination not to be separated by anything, so not (in
this example 6 out of 6) a,b,b,c,a,f but abbcaf. Also not to be enclosed
in parenthesis, single or double quotation marks etc. Just plain abbcaf etc.

I would like the combinations in a new workbook (started by the program),
sheet1 column A from row 1 as far down as it goes. And at starting the
program a message box that asks for the n characters of the basic set an for
the number p.

TIA for your help.

Jack Sons
The Netherlands
 
Jack Sons,

My Excel add-in "Display Word Combinations" may do what you want.
The list is added to the first empty column on the active sheet.
It works (only) for alphabetic characters and/or numbers.
Valid words are highlighted (with option to skip this part)
Comes with one page Word.doc install/use instructions.
It is available - free - upon direct request. Remove xxx from address.

Regards,
Jim Cone
San Francisco, CA
(e-mail address removed)
 
Jack Sons,
On second look, it probably doesn't do what you want as
the program only shows combinations of specified characters and does
not provide for subsets.

Regards,
Jim Cone
 
Jack
FYI, what your asking for is not technically a combination. In your example of 6 out of abcdefg, the total set of combinations would be

abcde
abcde
abcdf
abcef
abdef
acdef
bcdef

6C2 =

Regards
Mark Graesse
(e-mail address removed)

----- Jack Sons wrote: ----

Hi all

I would like to generate all possible combinations (not permutations, so on
combination of 6 out of the set abcdefg will also be aaaaab etc) of p ou
of n characters, n say from 3 to 8 and p from 3 to n. The character se
could contain (in principle) any character that can be obtained by alt plu
0 plus 3 numbers of the numerical keyboard (alt 0233 = é etc.)

The elements of each combination not to be separated by anything, so not (i
this example 6 out of 6) a,b,b,c,a,f but abbcaf. Also not to be enclose
in parenthesis, single or double quotation marks etc. Just plain abbcaf etc

I would like the combinations in a new workbook (started by the program)
sheet1 column A from row 1 as far down as it goes. And at starting th
program a message box that asks for the n characters of the basic set an fo
the number p

TIA for your help

Jack Son
The Netherland
 
Back
Top