+ Reply to Thread
Results 1 to 3 of 3

Generating a list of combinations

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    England
    MS-Off Ver
    2016
    Posts
    4

    Generating a list of combinations

    Hi guys,

    I need some help with generating a list of combinations. I have a list and I want a list of combinations -1 term then all the combinations-2 terms etc.

    for example if I have
    A
    B
    C
    D
    E

    I want an output of;
    B,C,D,E
    A,C,D,E
    A,B,D,E
    A,B,C,E
    A,B,C,D
    and then the combinations if 2 terms are removed;
    C,D,E
    B,D,E
    B,C,E
    B,C,D
    A,D,E
    A,C,E
    A,C,D
    A,B,E
    A,B,D
    A,B,C
    then 3 etc.
    The order within the combinations doesn't matter.

    I hope this makes sense.
    any help would be really appreciated.

  2. #2
    Forum Contributor
    Join Date
    09-28-2014
    Location
    harbin,china
    MS-Off Ver
    2007
    Posts
    162

    Re: Generating a list of combinations

    Hi,tomhardy

    Try this one
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Generating a list of combinations

    Hi tomhardy1491,

    Try my solution (thread 3) from this post.

    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generating full list of scenarios (or combinations) of data in columns
    By cparker347 in forum Excel General
    Replies: 6
    Last Post: 07-28-2015, 10:28 AM
  2. generating all possible combinations
    By tuckertuesday in forum Excel General
    Replies: 3
    Last Post: 12-10-2014, 06:24 PM
  3. [SOLVED] Generating all possible combinations per macro
    By KaNi2015 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 10-06-2014, 10:36 AM
  4. [SOLVED] Generating a List of Possible Permutation Combinations
    By glennchung in forum Excel General
    Replies: 3
    Last Post: 05-12-2014, 06:39 PM
  5. generating combinations
    By fern4500 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2012, 08:47 AM
  6. Help generating combinations
    By JamRock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2006, 03:40 PM
  7. [SOLVED] Generating excel combinations
    By mark4006 in forum Excel General
    Replies: 2
    Last Post: 03-06-2005, 01:06 PM

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