+ Reply to Thread
Results 1 to 2 of 2

Problem with combinations

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Problem with combinations

    Hello!
    I'm working with a big amount of data so this is about how to do something automatically. Let me explain what's the problem: I just did the combination of almost 2000 different cells (so following the formula C=n!/(n-k)!...with k=4), but now I'd like to do also the combination of each single row I obtained.
    Example

    1) sentence1 sentence2 sentence3 sentence4
    2) sentence1 sentence2 sentence4 sentence3
    3) sentence1 sentence3 sentence2 sentence4
    4) sentence1 sentence3 sentence4 sentence2
    5) sentence1 sentence4 sentence2 sentence3
    6) sentence1 sentence4 sentence3 sentence2
    ....

    So here I have the initial part of my combinations, and I'd like to insert after each row its own combinations (this second one, actually it's not a combination, it's a simple repetition of some of those elements that I need to do):

    (A) (B) (C) (D)

    1) sentence1 sentence2 sentence3 sentence4
    • A C B D
    • A D B C
    2) sentence1 sentence2 sentence4 sentence3
    • A C B D
    • A D B C
    3) sentence1 sentence3 sentence2 sentence4
    • A C B D
    • A D B C
    4) sentence1 sentence3 sentence4 sentence2
    • A C B D
    • A D B C
    5) sentence1 sentence4 sentence2 sentence3
    • A C B D
    • A D B C
    6) sentence1 sentence4 sentence3 sentence2
    • A C B D
    • A D B C
    ....

    Maybe I've not been so clear, but, considering one row at a time, I'd like to insert 2 more rows with the same elements, but in that particular order...of course, when you switch to another of the initial rows (for example from "1)" to "2)"...) the elements (sentence1, sentence2, sentence3...) change, so they would be different.

    Here is also another example about that order I'm trying to obtain.

    http://s18.postimg.org/richsxpmx/Col...bination_1.png

    Thank you in advance!
    Attached Images Attached Images
    Last edited by 18_types; 07-13-2013 at 02:56 PM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Problem with combinations

    Hi 18_types,

    Instead of images, suggest you to upload excel workbook along with your expected output. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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