+ Reply to Thread
Results 1 to 7 of 7

Combinatorics. Generator of combinations.

  1. #1
    Registered User
    Join Date
    09-04-2017
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    47

    Combinatorics. Generator of combinations.

    Hello everybody,

    I am looking for a formula which is behind the following website: https://planetcalc.com/3757/

    Simply, once I set up all the numbers I want to get all possible combinations of them. Thanks a lot!

  2. #2
    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,940

    Re: Combinatorics. Generator of combinations.

    Moved to the VBA section - this will most certainly require coding.
    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.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Combinatorics. Generator of combinations.

    Is this what you wanted??

    Enable macros...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    09-04-2017
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    47

    Re: Combinatorics. Generator of combinations.

    That is great. Would it be possible to remove duplicates? E.g. the combination 6,7 is the same as 7,6. Thanks

  5. #5
    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,940

    Re: Combinatorics. Generator of combinations.

    Don't you get that when you select C instead of P?

  6. #6
    Registered User
    Join Date
    09-04-2017
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    47

    Re: Combinatorics. Generator of combinations.

    Great! Sorry, I overlooked that. Thanks, SOLVED

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Combinatorics. Generator of combinations.

    Thanks, Ali, for the last bit...

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. Generator of Combinations
    By fab4x in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2016, 04:10 PM
  2. Generator combinations by SUM
    By b_rianv in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 09-22-2014, 07:53 AM
  3. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  4. Combinations generator
    By adyholo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-02-2011, 12:27 AM
  5. combinatorics with words
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2011, 05:45 PM
  6. Combinatorics Question
    By wondering2 in forum Excel General
    Replies: 3
    Last Post: 11-15-2010, 02:01 AM
  7. [SOLVED] Pin Generator
    By GoBucks in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 11:05 AM

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