+ Reply to Thread
Results 1 to 7 of 7

Combine digits in double digits in 4 numbers without repeating each other

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Combine digits in double digits in 4 numbers without repeating each other

    Hello, please help me in this work !!
    Generate all combinations of the following criteria
    Use all 10 digits = 0,1,2,3,4,5,6,7,8,9 Make 4 doubles combinations without repetition of digits each other
    Example = 01, 27,34,89 = 8 digits have distinct = corret
    You can not = 01 21 31 82 = Can not delete because it has the digit
    1.2 = repeated this training can not goal is to see all combinations of 4 doubles, without repeating digits in its
    Training = my excel 2010 windows8.1

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Combine digits in double digits in 4 numbers without repeating each other

    Hi,
    There will be probably quite large number of them.
    Let me make sure:
    a) 01 23 45 67 is fine
    b) 10 23 45 67 is OK too? or not? because the only difference is that pair 01 is just arranged different way
    c) 23 01 45 67 is probably (?) not acceptable because has the same pairs as in a)
    d) 01 23 45 61 is (of course) not acceptable because 1 appears twice.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Combine digits in double digits in 4 numbers without repeating each other

    Hello, kaper, thank you to see the post ok,
    There will probably be quite large number of them, no problem of the large number
    Let me make sure:
    a) 01 23 45 67 is good = yes is good
    b) 10 23 45 67 is OK too? It is also good !!!! Do too.
    c) 23 01 45 67 is probably (?) is not acceptable, because it has the same pairs as in a) do not, obviously, because it changed position but do not do this
    d) 01 23 45 61 is (obviously) is not acceptable because one appears twice. Corret has only appear once did
    * = goal is to see all combinations of four numbers without repeating digits as it is a standard that will fix, please, can make the macro?

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Combine digits in double digits in 4 numbers without repeating each other

    Hello, kaper can do macro? My excel 2010!
    Do you have any questions?

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Combine digits in double digits in 4 numbers without repeating each other

    There is more than 5M combinations, but because of condition c) - it is less than 100K.

    Run a macro below (it is already in the attached file) to list them all.
    Take your time - on my (not that bad) computer it takes 15.5 seconds to complete. Observe status bar - current progress is periodically reported there.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Combine digits in double digits in 4 numbers without repeating each other

    Hello, kaper, perfect, very good work, you are very clever !!! conglatulaçoes.
    When I win a good prize in the lottery, shall be rewarded.
    * The work was very good !!! thank you

  7. #7
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Combine digits in double digits in 4 numbers without repeating each other

    Hello, kaper, perfect, very good work, you are very clever !!! conglatulaçoes.
    When I win a good prize in the lottery, shall be rewarded.
    * The work was very good !!! thank you

+ 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] Looking for a formula to count single digits vs. double digits?
    By mnlaw in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-29-2023, 02:20 PM
  2. vlookup only the right most 4 digits of the 6 digits sequential numbers
    By tabcm66 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-02-2014, 07:33 AM
  3. [SOLVED] How to multiply a constant to only first 10 digits of 45 digits in a Logical Function
    By gz3s36 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-10-2014, 02:40 PM
  4. Changing digits after decimal to specific digits based on a criteria
    By mpatel000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-28-2012, 02:41 AM
  5. [SOLVED] Repeating specific digits
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2012, 05:35 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