J
jeep
How do you create a model to generate combinations of words or numbers
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Cone
jeep,
Very tediously.
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
[email protected]
Very tediously.
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
[email protected]
T
Tom Ogilvy
You seem to be using combinations and permutations interchangably. Johns
code does permutations. combinations are something different.
code does permutations. combinations are something different.
J
Jim Cone
Tom,
Thanks for pointing that out, I got careless...
"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
-snip-
Thanks for pointing that out, I got careless...
"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
-snip-