Generating 3 variables in a sequence of 10 in all possible permutations

[doogmas]

Sorry for the bad wording in the title.

Could anyone help me generate this set of data.
I have 3 variables; u, s, d. I need 10 letter sequence using only these in all possible orders.

Example for a 3 letter sequence:
u,u,u
u,u,s
u,u,d
u,d,u
u,s,u
etc.
where each letter is in it's own cell.

Thanks very much!
Sam

[amit.wilson]

Hi Sam,

hope I'm not working on someone's school assignment. :-)

Here's how I have thought through the problem. And correct me if I am wrong.

Say there were 10 letters instead of 3, and we had to generate 1,000 unique combinations. Then the easiest way to generate the permutation would be to write the series of numbers from 0 to 999. And then and substitute the numbers (0,1,2,..9) with the letters.

To do the same thing with 3 letters, we need a number series with base of 3 (i.e. 0,1,2,10,11,12,20,21,22,...)

In the attached sheet I've shown how to do this for 20 numbers. Can't do the whole set, the file becomes very heavy and slow. With repetition, there are 3^10 = 59,048 combinations possible.

Hope this helps.

Cheers

[kalak]

Sam,

here's a code to try.
run it from the VBA editor onto a blank worksheet

Please Login or Register  to view this content.

[doogmas]

Thanks imit.wilson

And thanks kalak, works a treat!

Thanks very much for both of your time.