Results 1 to 6 of 6

Combinations of all words on a row, in pairs

Threaded View

  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

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