+ Reply to Thread
Results 1 to 6 of 6

Combinations of all words on a row, in pairs

  1. #1
    Registered User
    Join Date
    08-21-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    2

    Combinations of all words on a row, in pairs

    I know the title is confusing, but I don't kow how to describe this otherwise.

    Here is the challenge I'm facing:

    I have a list of synonyms in word in the following format:

    A B C D
    word A1 Word A2 Word A3 (<-- all A-words are synonyms from each other on the same row)
    Word B1 Word B2 Word B3 Word B4 (<-- all B-words are synonyms from each other on the same row)



    Now I need the following output:
    Word A1 Word A2
    Word A1 Word A3
    Word A2 Word A1
    Word A2 Word A3
    Word A3 Word A1
    Word A3 Word A2
    Word B1 Word B2
    Word B1 Word B3
    Word B1 Word B4
    Word B2 Word B1
    Word B2 Word B3
    Word B2 Word B4
    Word B3 Word B1
    Word B3 Word B2
    Word B3 Word B4
    Word B4 Word B1
    Word B4 Word B2
    Word B4 Word B3


    If I try to explain it in words: I need all combinations of synonyms in pairs formatted in rows.

    I need this for a piece of software which allows import of synonyms, but the format has to be as above (each synonym on a row, in pairs).

    How would I accomplish this in Excel?

    I've uploaded an excel file with an example and on the second worksheet the complete synonym list (in foreign language, but that shouldn't matter)

    You can find it here:
    http://rapidshare.com/files/269768819/synonyms.xls.html

    I would appreciate it very much if someone can offer me a solution.

    Kind regards,
    Erik
    Last edited by bosserik; 08-21-2009 at 06:32 AM. Reason: Spelling mistakes

  2. #2
    Registered User
    Join Date
    08-21-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    2

    re: Combinations of all words on a row, in pairs

    ** Bumping this thread **

    Can anyone help me please ??

    Or else: where do I go to get help? I am willing to pay a small amount!

    Thanks
    E.

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    re: Combinations of all words on a row, in pairs

    Does this help?

    Only you need to enter words in columns, not rows.

    You can add to the right as many words you need only extend formula.

    I also assume not many synonim's, but if you need more just adjust ranges.

    Book2.xls

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    re: Combinations of all words on a row, in pairs

    Oh, yes, I hope you don't mind that same words repeats

    Word 1 - Word 1
    Word 2- word 2


  5. #5
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: Combinations of all words on a row, in pairs

    Hi
    With 11,574 rows of data there will be 15,05,602 permutations possible. How do you want them displayed? Attached workbook shows various permuations for 10 rows of your synonyms. If it is OK it can be extended to other rows.
    Ravi
    Attached Files Attached Files
    Last edited by ravishankar; 08-24-2009 at 03:36 AM.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Combinations of all words on a row, in pairs

    As I understand you combine only synonyms.

    For one object can't be much synonyms... A few...
    I just put them in separate columns, not as it showed above in same column.

+ 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