Hoping someone can help me with this one.
I have a column of words and I am trying to figure out all of the possible combinations that these words could be used together.
The Column of words is
Inspection
Shrink-wrap
Errata
ISBN Sticker
Remove Shrink-wrap
Wondering if there is a formula to find all the possible combinations of these words, without any duplicate combinations coming up. Example. Inspection and Shrink-wrap are the same as Shrink-wrap and Inspection
I hope this makes sense
On a blank sheet, drop all your words in column A starting at A1 going down, no blanks.
This macro will list all the combinations in column E.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you so much for this. I neglected to include that I am looking for all combinations, not just a 2 phrase combination. What should I modify in that Macro that would allow it to retrieve all possible combinations?
I wouldn't know how to do that. In my mind, to pull pairs requires 2 loops nested inside each other. So we could write one for 3 word combinations by nesting 3 loops, and 4 words with 4 loops, but I would always need to know in advance how many words we wanted so we could write the necessary loops.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
This code gives all combinations
Enter your words in A2:A6
For input range Enter A2:A6
since all combinations are required
Enter for Minimum number of selection 1
Enter for Maximum number of selection 5
For delimiter Enter required delimiter (EG:,) else leave blank .
You will get combinations from active cell down words.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks