Permutations 3 Columns

**seethesun** · 02-22-2013, 03:40 PM

Hi,

I am writing text ads for paid search. I want to be able to able to write a few text ads and have Excel generate permuations based on those text ads. I actually found an attachment in the forum that is almost exactly what I need. It just needs a little tweaking.

There is just one issue with the attached sheet

I want it to take into account more rows of text ads. Right now it's only looking at rows 5, 6, and 7. If I add something in the 8th row it doesn't take it into account when making the permutations. I'm just not sure how to change it so that it will take into account however many rows of input I include.

Permuation sheet.xls

Thanks for any assistance.

David

**Ace_XL** · 02-22-2013, 04:19 PM

Does the attached work for you?

**seethesun** · 02-22-2013, 04:44 PM

That is exactly what I needed! And now being able to compare the original versus yours, I can tell how it gets expanded, which is even better.

I'm still not certain how the formula works that pulls the permutations into the cells, but it works! Thanks Ace!