+ Post New Thread
Results 1 to 5 of 5
General Chat Thread, List: All Possible Combinations in General; Hi guys Not sure this is in the right section but here goes. I have a list of words, and ...
  1. #1
    SC-UK's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    569
    Thank Post
    36
    Thanked 85 Times in 71 Posts
    Rep Power
    30

    List: All Possible Combinations

    Hi guys

    Not sure this is in the right section but here goes. I have a list of words, and wondered how to list every possible combination of them using Excel or similar.

    For example, if the list contains Dog, Cat, Mouse, I need to produce another list of:

    Dog
    Cat
    Mouse
    Dog Cat
    Dog Mouse
    Cat Mouse
    Cat Dog
    Mouse Dog
    Mouse Cat
    Dog Cat Mouse
    Dog Mouse Cat
    Cat Mouse Dog
    Cat Dog Mouse
    Mouse Dog Cat
    Mouse Cat Dog
    .... and so on.

    The trouble is, the list I have is much longer than this. Impossible task to do easily?

    Help!!!

    Thanks

  2. #2

    Join Date
    Apr 2007
    Location
    Birmingham
    Posts
    142
    Thank Post
    6
    Thanked 45 Times in 39 Posts
    Rep Power
    22
    Something like this would do it, just have to run it multiple times for subset size required.

    Excel: number combinations, permutation and combinations, number combinations

  3. #3
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    this would be very easy in access.

    First you put a table in with all the words, including one blank field.

    Then you can create a query - include the table mupltiple times with the field that has the words as an output, once for each item in the list if you want every possible combination.

    run the query and you will get a table with each combination in each row.

    This will include repetition so Dog, Dog, Dog would come up as well as Cat, Dog, Mouse.

    If you did not want this then it would just be a question of putting in conditions in the queries to say they must not match other columns.

    But this does depend on how many words you have got, too many would probably make access fall over.

    If it was me then I would probably do it with vb script - but this depends on how comfortable you are with script.

  4. #4
    Gerry's Avatar
    Join Date
    Jun 2007
    Location
    North Wales
    Posts
    431
    Thank Post
    60
    Thanked 38 Times in 35 Posts
    Rep Power
    24
    I think I'm correct with this...

    Factorial - Wikipedia, the free encyclopedia

    If your have 5 words in your list you will get 120 combinations,
    6=720
    7=5,040
    8=40,320
    and before you know it your into some massive numbers

    Actually, not quite right, since your combinations will include ones that aren't made up of the full set and no repetition, but your still talking massive numbers.
    Last edited by Gerry; 18th February 2010 at 03:11 PM.

  5. #5
    SC-UK's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    569
    Thank Post
    36
    Thanked 85 Times in 71 Posts
    Rep Power
    30
    Excellent responses - thanks for all your help, I will have a look and try and work out what I'm doing (once I know exactly what's required from the list of course!).

SHARE:
+ Post New Thread

Similar Threads

  1. What's on your xmas list?
    By Little-Miss in forum General Chat
    Replies: 28
    Last Post: 18th November 2008, 10:12 AM
  2. Proxy list...
    By dave.81 in forum General Chat
    Replies: 2
    Last Post: 19th September 2007, 11:28 AM
  3. ToDo List
    By sqdge in forum General Chat
    Replies: 14
    Last Post: 1st August 2007, 07:11 AM
  4. List your policies
    By GrumbleDook in forum School ICT Policies
    Replies: 0
    Last Post: 13th March 2007, 08:55 AM
  5. A list of
    By wesleyw in forum General Chat
    Replies: 8
    Last Post: 29th September 2006, 02:50 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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