John Walkenbach has a small piece of recursive code, of unknown origin, on his web site that
does combinations. I have yet to hear from anybody that actually understands it. (I don't)
I've written an Excel add-in "Display Word Combinations" that uses that code along with
6 plus pages of additional code. The add-in does the following...
All possible permutations for a series of characters are determined.
( 3 to 8 characters - letters or numbers)
Duplicate combinations are eliminated and a listing of the result is added
to the first empty column on the worksheet.
Valid words in the list are highlighted and shown at the top of the list.
The add-in is available - free - upon direct request.
Remove xxx from my email address.
Regards,
Jim Cone
San Francisco, CA
(e-mail address removed)
"Fundamental Statistics for the Behavioral Sciences"...
Combinations: The number of ways objects can be selected without regard to order.
Permutations: The number of ways objects can be arranged taking ordering into account.
Regards,
Jim Cone
San Francisco, CA
Tom Ogilvy said:
You seem to be using combinations and permutations interchangably. Johns
code does permutations. combinations are something different.
Regards,
Tom Ogilvy
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
