PDA

View Full Version : Concantenate Loop



firebugabc
06-21-2006, 04:10 PM
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

austenr
06-21-2006, 04:44 PM
Sounds like a homework problem:thumb

firebugabc
06-21-2006, 07:48 PM
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:(

XLGibbs
06-21-2006, 08:25 PM
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.