Hello!
I am trying to create a random word generator - it creates words from 2 and 3 parts located in the corresponding columns - it does it randomly but I want to list all the possible combination for both the 2-part and 3=part word combination - can you please help me do that? Maye there is a way to do that with a macro that can be easily adjusted to work on more source components - now the file works on the first 20 rows of the 3 columns.
Thanks!
Dima
zealot,
See:
Posts: 59 Create list of all pair combinations
http://www.mrexcel.com/forum/showthread.php?t=412952
Sub PermutWords()
By pgc01
http://www.mrexcel.com/forum/showthread.php?t=371960
Last edited by stanleydgromjr; 08-12-2010 at 08:46 PM.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Drag the formulas down 10,000 rows or so.
Entia non sunt multiplicanda sine necessitate
Thank you very much Shg - it works exactly like I wanted it to work!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks