Keyword Permutations

[gimmeexcel]

I'm not sure if this is possible, but...

I'm trying to create all possible permutations for a string of keywords in a ell.

For instance, Cell A1 contains: Black Air Max M200 Super Light Basketball Shoe

So that's 8 words, and I need all possible 2, 3, 4, 5, 6, 7, and 8 word combinations in EVERY possible word order.

Is it possible to do this? And what would it take to accomplish this in the most efficient manner, perhaps a built-in function?

Many thanks in advance!

 

[njimack]

Is this what you're after?
=FACT(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))

 

[gimmeexcel]

Hi njimack

Looks like this formula just counts the number of possible variations but it does not give me the actual phrases -- which I need.

Thanks anyway, though

 

[shg]

For eight unique words taken 2 through 8, I think there are =SUMPRODUCT(PERMUT(8,{2,3,4,5,6,7,8})) = 109,592 permutations. What would you do with them all?

 

[njimack]

Sorry, misunderstood what you wanted.

 

[gimmeexcel]

Hi shg,

Thanks for the formula. How would I input this into the worksheet to generate the combinations? Is this an array?

I'm doing this for online marketing and I'm looking to generate keyword lists based on the keywords that appear in title tags -- and then cross reference the search volumes with keyword research tools

 

[shg]

I wouldn't know how to do it with formulas. Do you know how to use VBA?

Why does order matter if you're looking for words?

 

[gimmeexcel]

Well I want the words to be grouped together in phrases of varying lengths. So that's why word order does matter.

I think VBA would be the best solution. I'm hoping to get some examples

Thanks

 

[shg]

See http://www.box.net/shared/f3puhccnqa

You'd have to convert to Excel 2007+ to handle eight words, and even that wouldn't handle more than nine.

 

[xenou]

Surely most search engines would be able to search using OR expressions:

word1 OR word2 OR word3 ... OR word8