Results 1 to 2 of 2

Thread: Generating All Possible Combinations - 4 Duplicate Lists

  1. #1

    Unhappy Generating All Possible Combinations - 4 Duplicate Lists



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello!

    I'm really struggling to list all combinations of 4 duplicate lists that I have. I would MASSIVELY appreciate some help on this as I cant see on the forum anyone with quite the same issue, apologies if this is somewhere out there though.....! :S

    Here is what I have:

    Type 1 Type 2 Type 3 Type 4
    40 or less 40 or less 40 or less 40 or less
    50 or less 50 or less 50 or less 50 or less
    60 or less 50 or less 50 or less 50 or less
    70 or less 70 or less 70 or less 70 or less
    80 or less 80 or less 80 or less 80 or less
    90 or less 90 or less 90 or less 90 or less
    90 or more 90 or more 90 or more 90 or more

    I'm trying to get to the point where I can list all combinations of the above. The Types must remain in the same order, but the values are to mix. An example of this would be below:

    Type 1 Type 2 Type 3 Type 4
    40 or less 50 or less 60 or less 70 or less
    70 or less 70 or less 90 or less 90 or more
    60 or less 40 or less 90 or more 90 or more

    Does anyone have any suggestions?

    Thanks so much everyone,
    Matt

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,708
    Articles
    0
    Excel Version
    365
    In the attached:
    1. Columns F:I contain formulae to give all numbers from 1 to 7 in all their combinations (the 4 cells F1:I1 copied down).
    2. A little INDEX formula in columns K:N which uses the numbers in F:I (cell K1 copied across and down).
    3. Columns P:S is just a merge of the formulae in 1 and 2 above, and gives the same result.
    4. Columns U:X is the values of P:S with Remove Duplicates applied (you have 50 or less appearing twice in each of Types 2,3, & 4).
    5. BTW, a 90 would go into where; 90 or less, or 90 or more, or both?
    Attached Files Attached Files
    Last edited by p45cal; 2017-03-24 at 10:32 PM.

Tags for this Thread

Posting Permissions

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