Record all Random Words from Lists of Letters

[zealot]

Hello!)
I am trying to generate random words from the list of the vowels and the consonants standing in different columns - I am using F9 to recalculate next bunch of the random words but I wish to collect all of them in one single list. Can you please help me do this? In the future I plan adding more columns to the green area shown in the attached worksheet.
Hoping to hear form you soon!)
Thanks!
Dima

[zealot]

PS: It woudl also be great to be able to calculate the number of all unique words that can be calculated by the given number of the letters in the different columns.
Thanks!

[Marcol]

Try this to start with, I get the feeling that your criteria is maybe different from what your sample suggests.

Please Login or Register  to view this content.

I have used conditional formatting to display your table of results.

Hope this helps

[zealot]

THANK YOU VERY MUCH FOR THIS MACRO....DO you think it can be modified to take into the account those cases when I need less or more columns with the letters to use in the word generation? I tried running it on 3 columns and it does nto seem to work properly.
Thanks a lot!)

[zealot]

Also when i leave only one consonant in teh second column - say r - it does not generate all the words for the consonants in the fourth column
thank you!)
dima

[Marcol]

This will cure the problem you describe in Post #5, when 5 columns are used.

Please Login or Register  to view this content.

What 3 columns did you try to use the code on?

How many columns do you see using and what would they contain?

As I suspected this could become quite complex, as the number of columns used increases.

Can you post a sample of these new arrangement?

[shg]

Here's a formula-based approach.