+ Reply to Thread
Results 1 to 12 of 12

Combination Generator for Single List

  1. #1
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Combination Generator for Single List

    Respected Members,
    I am a Ph.D. Scholar in Japan. I need a combination generator on an almost daily basis for my data analysis. As you all are well aware of the student's situation in this pandemic. I have seen one video on youtube and exactly this sheet 1 needs but paid. I am unable to buy this sheet. I am requesting all experts in this group to help e in this regard. I am attaching the Video link for the reference file. I am not allowed to paste the link here below is the title of the video on youtube.

    Reference file: Combinations Generator Excel Template - Single List - No Repetitions

    Seeking an encouraging response.
    Attached Files Attached Files
    Last edited by Montecarlo1; 06-19-2021 at 08:22 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Combination Generator for Single List


    Hi,

    follow at least the top page yellow banner in order to attach a workbook with source data and expected result accordingly …

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Combination Generator for Single List

    Please share what you have done so far and then members can help. NOBODY is going to watch a YouTube clip, build the solution and hand it to you on a plate. Sorry - you have got the wrong idea of the way it works here. We offer HELP only, we do not work to a brief. I hope you understand.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Re: Combination Generator for Single List

    So sorry members. I have uploaded the file basically I don't know any programing language so I don't know the VBA.

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: Combination Generator for Single List


    According to your attachment, what is the purpose of R value within cell E2 ?

    Is your column I result complete ?

  6. #6
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Re: Combination Generator for Single List

    R means how many combinations like shows R= 1 combination
    DS
    LCS
    CSRP
    OE
    If R=2
    DS, LCS
    DS, CSRP
    DS, OE
    LCS, CSRP
    CSRP, OE
    CSRP, OE and so on.

  7. #7
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: Combination Generator for Single List


    So according to your attachment where R = 3 how do you explain your result in I15 = DS/LCS/CSRP/OE ?

  8. #8
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Re: Combination Generator for Single List

    R=1
    ds
    lcs
    csrp
    oe

    r=2
    ds/lcs
    ds/csrp
    ds/oe
    lcs/csrp
    lcsr/oe
    csrp/oe

    r=3
    ds/lcs/csrp
    ds/csrp/oe
    lcs/csrp/oe
    ds/lcs/oe

    r=4
    ds/lcs/csrp/oe


    In R=3 in excel sheet i just gave example that the out put in column I is not according to R=3. You can see above i have discussed about R.
    Last edited by Montecarlo1; 06-19-2021 at 09:31 PM.

  9. #9
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Re: Combination Generator for Single List

    Thanks for your consistent help and support.
    Last edited by Montecarlo1; 06-19-2021 at 09:32 PM.

  10. #10
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Post

    (removed for new version)
    Last edited by Marc L; 06-19-2021 at 10:44 PM.

  11. #11
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Try this !


    According to your attachment a VBA demonstration as a beginner starter
    to paste to the top of a module (like the Sheet1 worksheet module) :

    PHP Code: 
    Dim D$, K&, R&, S$(), V()

    Sub Combinate(Optional L& = 1Optional P& = 1Optional T$)
        
    Dim C$
        For 
    P To UBound(V) + (1) * (1)
            
    V(P1)
            If 
    K Then Combinate L 11Else 1S(R0) = C
        Next
    End Sub

    Sub Demo1
    ()
            [
    I1].CurrentRegion.Offset(1).Clear
            K 
    = [E2].Value2
            V 
    Range("A2", [A1].End(xlDown)).Value2
        
    If UBound(VThen
            Beep
        
    Else
            
    ReDim S(1 To Application.Combin(UBound(V), K), 0)
            
    = [E6].Text
            R 
    0
            Combinate
            
    [H1].Value2 R
            
    [I2].Resize(R).Value2 S
        End 
    If
            
    Erase SV
    End Sub 
    ► Do you like it ? ► So thanks to click on bottom left star icon « Add Reputation » !
    Last edited by Marc L; 06-19-2021 at 11:06 PM. Reason: tiny optimization …

  12. #12
    Registered User
    Join Date
    05-20-2021
    Location
    Malaysis
    MS-Off Ver
    365
    Posts
    17

    Re: Combination Generator for Single List

    It's perfectly working as I want. Thank you so much dear

+ 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] Is This Possible? (Combination Generator)
    By BornInTheFlame in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2020, 11:23 PM
  2. [SOLVED] Combination Generator Macro
    By ssjagger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2018, 10:41 AM
  3. Combination Generator
    By lorber123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2016, 06:32 AM
  4. Combination Generator
    By Willyp133 in forum Excel General
    Replies: 0
    Last Post: 03-18-2015, 09:23 AM
  5. [SOLVED] Combination Generator
    By kenny.fsw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2014, 12:33 PM
  6. 'In order' combination Generator
    By daisytiara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2013, 12:03 PM
  7. combination generator needed
    By smiso24 in forum Excel General
    Replies: 16
    Last Post: 04-12-2010, 07:18 PM

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