Hi,
Lets say I have data in 5 cells in sheet1:
a1 b1 c1 d 1 e1
How can I write a loop to get all possible combinations of the text in each cell written to cells in sheet2?
So, in this example there would be 120 strings created.
Thanks
Hi,
Lets say I have data in 5 cells in sheet1:
a1 b1 c1 d 1 e1
How can I write a loop to get all possible combinations of the text in each cell written to cells in sheet2?
So, in this example there would be 120 strings created.
Thanks
Sounds like a homework problem
Peace of mind is found in some of the strangest places.
Actually it is a real world problem, if I was still in school I could answer it myself. I am dumb in my old age
Sounds tricky...I guess the first question is why do you need to iterate through all the variations? Is the goal to simply create a list of them?
It can be done, but I will have to dig through some code to find the right mix...will post a sample back if I find it before too lpng.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!