+ Reply to Thread
Results 1 to 9 of 9

how many formations are possible, but in ascending order from 7 to 0 to 9?

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

    how many formations are possible, but in ascending order from 7 to 0 to 9?

    how many formations are possible, but in ascending order from 7 to 0 to 9?
    ex = 2998776
    crescent = 2677899, (I want it like that) the 7 digits must always be
    in ascending order
    another example = 0111111. 0111112, ......
    8999999. So we have from 0 to 9 and formations increasing from 7 positions,
    when it’s not growing we have 10 million, but I need it in increasing order, it should decrease a lot
    https://www.excelforum.com/attachmen...1&d=1601896308
    Attached Files Attached Files

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    hello, please!

  3. #3
    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,616

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    it's indeed less. just 11440
    I reused a code from previous thread https://www.excelforum.com/excel-pro...-position.html with minor changes. The changes are marked red:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,

    Kaper

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    the probabilities of one or two pairs of repeated digits
    singles> 584 5.84%
    1 pair> 4312 43.12%
    2 pair> 3269 32.69% filters
    3 pair> 541 5.41%
    other> 1294 12.94%

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    huu, kaper, good job now filter and separate
    within 11440 those that have two repetitions of digits, type 2994776 99.77 or 45651201 55 11
    should be 11440 = 32%
    this pattern of having two repetitions is happening 90% in the draws

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    kaper
    Super Sete:

    01 10/02/2020 2998776
    02 10/05/2020 8815677
    03 10/07/2020 7266544
    04 10/09/2020 5781825
    05 10/14/2020 6401069
    06 10/16/2020 5733411
    07 10/19/2020 0776449
    08 10/21/2020 7092025
    09 10/23/2020 8620267

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    kaper is a new lottery, super seven
    you will see that more than 90% have two digits
    repeated and of course there are 5 different digits in the 7 positions or columns, I need to separate only
    formations within 11440 those that have two digits repeated, which is what is happening in 90% of the draws, I know of course that it is growing

  8. #8
    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,616

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    I think it is totaly different question.
    The question you asked in post #1 has been answered in post #3
    If it is answered - it would be nice to mark thread SOLVED and (if you think the answer was warth it) add me reputation. Question in posts #4-#7 shall be published in separate thread - they are not about " how many formations are possible, but in ascending order from 7 digits 0 to 9?"

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

    Re: how many formations are possible, but in ascending order from 7 to 0 to 9?

    ok, yes this is resolved, I'll open another
    topic for this question of the pairs

+ 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] how many formations do you have in ascending order with 5 positions with 0 to 9 digits?
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2019, 10:43 AM
  2. [SOLVED] Date Ascending Order and other data alphabetic order
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2019, 08:12 AM
  3. how many formations are possible using ascending strings? *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-12-2019, 03:05 PM
  4. Replies: 7
    Last Post: 02-07-2019, 08:18 PM
  5. Replies: 14
    Last Post: 08-12-2017, 11:11 PM
  6. Formations of 6 digits in ascending order
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2014, 02:11 PM
  7. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 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