+ Reply to Thread
Results 1 to 19 of 19

identify the initial and final cracks * odd / even.

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

    identify the initial and final cracks * odd / even.

    identify the initial and final cracks
    * odd / even.
    objective = identify in each line of draw the string (combination of cracks) the cracks are numbered from 01 to 35

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

    Re: identify the initial and final cracks * odd / even.

    https://www.excelforum.com/attachmen...1&d=1559392232
    Attached Files Attached Files

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: identify the initial and final cracks * odd / even.

    What does "cracks" mean please?
    Please use terms akin to Excel so that everybody can understand them.
    Thanks

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

    Re: identify the initial and final cracks * odd / even.

    ok pepe, sorry,
    * well we have 4 groups of 35 suits
    I forgot to put 01 to 35 in the other three groups of suits also these suits will always be the same,
    * each draw line will identify these 4 suits
    * initials and endings. its use is 95%
    * some draw will have all 4 suits, no problem

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: identify the initial and final cracks * odd / even.

    What is the difference with you other thread? https://www.excelforum.com/excel-pro...ml#post5129955

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

    Re: identify the initial and final cracks * odd / even.

    Sorry, there is no difference, I thought I had not posted on the forum, sorry, it's the same request
    * please !!!!

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

    Re: identify the initial and final cracks * odd / even.

    Sorry you are correct, I noticed after I posted the second post.

  8. #8
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    Does this post concern with pick-3 lotteries and 6-digit games less than 45 numbers?

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

    Re: identify the initial and final cracks * odd / even.

    hello angexcel, thanks for viewing the post
    * no, it's a 25/15 lottery we have 25 numbers
    * from 01 to 25, and 15 are drawn, if 15 numbers are played
    * so it was divided into 5 columns of numbers (broken or threes), the goal is to hit the 1st trio with the last trio, not the whole sequence of 15 numbers, but the initial 3 and the final three
    * lotofacil 25/15 brazil

  10. #10
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    I'm really wondering if anyone here knows some VBA formulas for the following tasks:
    a) Counting the frequency of each number in a lottery game

    b) Determine which are "hot" numbers, "cold" numbers and "overdue" numbers within a certain draw period in a lottery game

    c) Know how many times a number is paired with another number

    I am concerned with lottery games where you draw 6 numbers from a number pool.

  11. #11
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: identify the initial and final cracks * odd / even.

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    You already have a thread open - https://www.excelforum.com/excel-gen...ion-tasks.html
    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.

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

    Re: identify the initial and final cracks * odd / even.

    ok that's a good study you have to open another post and setting up the planilia

  13. #13
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    No - this is an entirely new concern. And according to Ms. AliGW, my concern is related to yours regarding the lottery. So I did a search but none that appeared deals with my specific concern. So I was forced to ask that of you to comply with the forum "rules".

  14. #14
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    You know what? I already did your advice in searching posts made by member "Jorel" regarding the lottery.
    I did that search and looked up every single one he made allegedly touching on that topic - two search results pages in fact.
    Practically, NONE - as NOT EVERY SINGLE ONE OF THEM - directly dealt with my concern.

    I am dealing directly with Jorel himself so he can help direct me to my concern - if any related post really did already exist in the first place... As far as my search results here has told me, there are none.

    Please, kindly cut me some slack. I just NEED the info I'm asking for.Untitled.jpg
    Last edited by angExcel-entflea; 08-06-2019 at 10:06 AM. Reason: Add an image

  15. #15
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: identify the initial and final cracks * odd / even.

    I am sorry that none of Jorel's posts helped you. My advice was simply to look and see if they were of any use. If they are not of use, then you need to continue in your own thread here: https://www.excelforum.com/excel-gen...ion-tasks.html

    Jorel is perfectly capable of following the link and helping you there. Please do as you have been asked. Thank you.

  16. #16
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    I am posting this reply as an apology if my previous statement bore some resentment on my part. I hope Jorel would know about what I'm asking for. If not, I hope he can refer me to someone in this forum, or outside of it, who can...

  17. #17
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: identify the initial and final cracks * odd / even.

    Please continue in your own thread. I have bumped it up for you by posting to it again. There is a link to it in post #15 above.

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

    Re: identify the initial and final cracks * odd / even.

    but I do not know how to create macro, formulas etc, you have to set up the planilia, so the most experienced of the forum can give a way, frequency by vertical position, it is good study 50% 35% 15% hot cold medium in each position ,
    but learn lotteries so you can get to some extent the rest is random, like 80/20
    * one aprte always depends on luck 20% the other on math 80% then 80/20

  19. #19
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    Re: identify the initial and final cracks * odd / even.

    Reply for jorel:

    Let's kindly continue the discussion in the thread posted by admin, Ms. AliGW.... (To thread https://www.excelforum.com/excel-gen...ion-tasks.html)

    I'm not expecting much - but by reading the thread there, you might have ideas that no one knows yet. (Though you don't know about macros, VBA formulas, etc.)

+ 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. detect from 1 to 35, the cracks initial and final, even and odd .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2019, 03:21 PM
  2. [SOLVED] Separate the two cracks in two blocks, and add the last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2018, 08:03 AM
  3. [SOLVED] Difference between initial time and final time code not working correcly!
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2017, 06:28 AM
  4. [SOLVED] Separate the cracks that has only two digits repeated
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-10-2016, 11:33 PM
  5. Data Analysis: Compare initial date with final date by looking up the latest revision
    By White_Glint in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2015, 02:31 PM
  6. Replies: 3
    Last Post: 03-05-2015, 02:33 PM
  7. [SOLVED] Find initial value, final value & missing entries
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 07-08-2014, 10:04 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