How do you create a model to generate combinations of words or numbers

--
Message posted from http://www.ExcelForum.com

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
XX

"jeep " wrote in message ...
How do you create a model to generate combinations of words or numbers?
Message posted from http://www.ExcelForum.com/

You seem to be using combinations and permutations interchangably. Johns
code does permutations. combinations are something different.

--
Regards,
Tom Ogilvy

"Jim Cone" wrote in message
...
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
XX

"jeep " wrote in message
...
How do you create a model to generate combinations of words or numbers?
Message posted from http://www.ExcelForum.com/

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

"Tom Ogilvy" wrote in message ...
You seem to be using combinations and permutations interchangably. Johns
code does permutations. combinations are something different.
Regards,
Tom Ogilvy

-snip-