+ Reply to Thread
Results 1 to 2 of 2

Generate a list of all possible combinations

  1. #1
    Forum Contributor
    Join Date
    07-17-2020
    Location
    Uzbek
    MS-Off Ver
    Office 365, V 2212
    Posts
    198

    Post Generate a list of all possible combinations

    Hi Experts,
    I want to generate a list of all possible number combinations within a set of seven numbers using all numbers from 0 through 9.
    The set of combinations can be repeated and it may look as following; 4,6,1,1,6,0,9 or just 7,7,7,7,7,7,7
    So, I'd appreciate it if somebody could provide a solution/macro.

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Generate a list of all possible combinations

    in total 100.000.000 possible combinations starting at "0000000", "0000001", "0000002","0000003",....,"9999999".
    No need for a macro
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ 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 code to generate subsets of all combinations of list items reasonable?
    By Dimensional in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2020, 07:34 PM
  2. vba to generate combinations
    By thoandros in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2018, 09:20 AM
  3. [SOLVED] How to generate a list of all possible combinations of items
    By StuCram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2015, 02:11 PM
  4. read array of values to generate a list of combinations
    By envy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2014, 12:14 PM
  5. List of 15 elements, need to generate all 6 element combinations.
    By j4c0b5m17h in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2013, 02:11 PM
  6. [SOLVED] Run-time error 6: Overflow - Trying to generate list of combinations
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-22-2013, 10:54 AM
  7. Generate list of possible combinations
    By Pat Parker in forum Excel General
    Replies: 2
    Last Post: 03-14-2010, 03:34 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