+ Reply to Thread
Results 1 to 10 of 10

Multiple combination generator

  1. #1
    Registered User
    Join Date
    06-18-2008
    Posts
    6

    Multiple combination generator

    Hello People,

    I have a workbook with loads of worksheets in. There are lists of keywords in cols. A-I. I need to combine these words to make all possible strings of words in certain combinations.

    EG: in col: J the title is: C-A-E, And in this column I need all the combinations of words in columns C, A and E.

    Theit are other columns with different combinations. can I get excel to look at the column name and then make the selections of col.s to combine?? I would like to make a macro to do it really.

    The problem is all the worksheets are different, Any help appreciated. I am currently using DigDB, and it is ok, but still takes too long fr me!!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Would you post an workbook, and show an example of desired output?

  3. #3
    Registered User
    Join Date
    06-18-2008
    Posts
    6

    Example

    Here is one Page of the work book. Please bare in mind that on some of the other pages there may be less rows of source words, and in some cases the rows that are being asked to be combined will be different, so the marco or however else it can be done needs to be fairly dynamic.

    Thanks to anyone who might have some suggestions, I know its a tricky one!
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    It's not hard, it just consumes a lot of space.

    Taking one word from each column in all possible combinations would require 9,331,200 lines to list.

    Maybe you need a different approach?

  5. #5
    Registered User
    Join Date
    06-18-2008
    Posts
    6

    Not Sure what you mean!

    I need the complete list of tge combinations that are listed. When I get the worksheets they look like this. (please see attached) and the previous attachement is the desired result!

    def. possible, but not as large as I think you think!

    I need the whole list to upload into google
    Attached Files Attached Files

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Here are some examples. You need to extend the array formulas down to cover the combinations.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-18-2008
    Posts
    6

    I might just be being silly

    But the MakeCombos functions doesnt seem to work. Im just getting
    #Name?

  8. #8
    Registered User
    Join Date
    11-20-2009
    Location
    Mongolia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Multiple combination generator

    How to combine combination from 56 to 10.
    I use other software. But it can not be fitted in Excel.
    It is too big.
    Please help.

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Multiple combination generator

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then start your own thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Registered User
    Join Date
    01-21-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Multiple combination generator

    This article has Free VBA code that will generate Word Combinations if you provide a list of characters.

    Click on this link to get the Excel VBA Code for Word Combination Generator.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1