View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe B.[_3_] Joe B.[_3_] is offline
external usenet poster
 
Posts: 6
Default Number Switch Code

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?