+ Reply to Thread
Results 1 to 7 of 7

to generate random formations with 40 numbers with the double palindrome from 01 to 98 *

Hybrid View

jorel to generate random formations... 04-28-2019, 10:19 AM
MickG Re: to generate random... 04-28-2019, 10:42 AM
Logit Re: to generate random... 04-28-2019, 05:26 PM
jorel Re: to generate random... 04-28-2019, 09:10 PM
jorel Re: to generate random... 04-28-2019, 09:11 PM
Logit Re: to generate random... 04-28-2019, 09:55 PM
jorel Re: to generate random... 04-29-2019, 08:32 AM
  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,318

    to generate random formations with 40 numbers with the double palindrome from 01 to 98 *

    to generate random formations with 40 numbers with the double palindrome from 01 to 98
    * we have 10 twin pairs 00 11 22 33 44 55 66 77 88 99 these do not enter the formation

    * ex = 42 24 32 23 ... 40
    5000=formatios

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    Try:-
    Sub MG28Apr44
    Dim Rng As Range, Dn As Range, n As Long, Num As String, nNum As Long, ac As Long, Rw As Long
    Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
    With CreateObject("scripting.dictionary")
    .CompareMode = vbTextCompare
    For Rw = 1 To 5000
    ac = 0
    For n = 1 To 98
    Num = Format(n, "00")
    If Not Right(Num, 1) = Left(Num, 1) Then
            .Item(n) = Num
    End If
    Next
        Do Until ac = 40
            nNum = Application.RandBetween(1, 98)
            If .exists(nNum) Then
                ac = ac + 1
                Cells(Rw, ac).NumberFormat = "@"
                Cells(Rw, ac) = .Item(nNum)
                .Remove nNum
            End If
        Loop
    Next Rw
    End With
    
    End Sub
    Regards Mick

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,400

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    .
    I've looked around the Internet to learn the background of double palindromes. The articles were interesting, informative
    and fun to learn from.

    Aside from the pattern that is created ... what is the purpose of double palindromes ?

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

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    hello,logit logit, goal is to play only one of the number of the pair polindromo ex = 32,23, or if you play 32 or 23 numca the two together, you can see in the lottery results, the pair polindromo is rare

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

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    helo MICKG) corret, perfect, conglatutations,
    thank you!

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,400

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    .
    Thank you jorel.

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

    Re: to generate random formations with 40 numbers with the double palindrome from 01 to 98

    hello, MICKEY, ok you can now generate 40 numbers, plus 20 polynomial pairs, and each formation must have 20 polynomial pairs,
    example = 23 32 45 54 85 58 ...... 5000 formations

+ 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. generate random formations, but in the following factions .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2018, 07:27 AM
  2. hello please generate formations of 5 numbers in the criteria *.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2018, 11:15 AM
  3. [SOLVED] Generate random formations, but without repeating the letters in the columns and in the ro
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-13-2017, 01:15 PM
  4. [SOLVED] generate random numbers between 1 to 10 vba rnd()
    By ihrktho in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2014, 09:51 AM
  5. Generate Random Numbers Between 0-9
    By dreicer_Jarr in forum Excel General
    Replies: 11
    Last Post: 01-17-2014, 01:00 AM
  6. [SOLVED] Generate Random numbers where sum = 1
    By sajeel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2013, 07:12 AM
  7. [SOLVED] Generate Random Numbers
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2013, 02:49 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