display permutations in excel

[spudgun44]

I have 10 columns each with a possible 3 cell entries.

I need somthing that will display the permutations that can be possible.

I dont need the number of pssability I need the possibilites themselves

ie:

aaa
aab
aba
baa
bba
bab

 

[VoG]

Try this http://www.mrexcel.com/forum/showthread.php?t=379323&highlight=myrna+larson

 

[spudgun44]

thanks for the swift responce,

I used letters for the example as it was easy to display, the cell entries would be more complect than that.

What I was looking for was if 10 columns has 3 possible entries (regardles of what the entries were) could something work out the possible cominations and display them

The link that you provided I think would only do this with letters

 

[VoG]

No, it will work with numbers. You have to arrange your data in the format specified.

 

[spudgun44]

I sound really thick but I do I get it to work?

I have coppied the code and pasted it in but what triggers it to run?

 

[VoG]

Press ALT + F8, double click ListPermutations

 

[spudgun44]

cheers this is great

thank you