Joe

John Walkenbach has a Permutation Generator workbook downlaod at

http://www.j-walk.com/ss/excel/tips/tip46.htm

Gord Dibben Excel MVP

On Sat, 10 Jan 2004 11:16:33 -0800, "Jim Cone" wrote:

Joe,

If you don't want to do it yourself then...
I have written an Excel add-in "Display Word Combinations".
It should do what you want...

All possible combinations for a series of characters are determined.
(alpha and or numeric)
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.
It handles 3 to 8 character combinations and comes
with a one page Word.doc install/use file.
It is available (for free) upon direct request.
Remove the xxx from email address.

Regards,
Jim Cone
San Francisco, CA
XX

"Joe B." wrote in message
...
Does anyone have some good number shuffling code? If I
have up to 10 one digit numbers in a list, I would like
to see all the different orders the numbers to go in.
for example, if there were 3 numbers: 1, 3 and 5 the code
would produce the following number combination orders:

1,3,5
1,5,3
3,5,1
3,1,5
5,1,3
5,3,1

Of course it gets more complicated when you add more
numbers. Anyone?