+ Reply to Thread
Results 1 to 10 of 10

detect in the blue line the numbers that were drawn correspondingly.

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

    detect in the blue line the numbers that were drawn correspondingly.

    detect in the blue line the numbers that were drawn correspondingly, if possible see those that repeat from the last draw to the next on the blue list
    https://www.excelforum.com/attachmen...1&d=1739388596
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,679

    Re: detect in the blue line the numbers that were drawn correspondingly.

    You have had multiple examples of this (formula-based) calculation in previous (2000+) posts so make an effort - for once - to D.I.Y.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

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

    Re: detect in the blue line the numbers that were drawn correspondingly.

    ok but for someone who has never made a macro it is an impossible task

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,679

    Re: detect in the blue line the numbers that were drawn correspondingly.

    It does NOT need a macro! Look at COUNTIF function: you have had numerous example of EXACTLY the same requirement. Do you throw away all solutions given to you?!

  5. #5
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,955

    Re: detect in the blue line the numbers that were drawn correspondingly.

    jorel has been addressed by multiple members regarding this...He is just not interested to learn as it all gets done for him anyway...
    Remember, the reason for all his posts is merely to win the lotto...
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,679

    Re: detect in the blue line the numbers that were drawn correspondingly.

    Remember, the reason for all his posts is merely to win the lotto...
    If it could be done using statistics, there would be many milionaire statisticians!

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

    Re: detect in the blue line the numbers that were drawn correspondingly.

    hello,sintek

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,955

    Re: detect in the blue line the numbers that were drawn correspondingly.

    As per John...

    you have had numerous example of EXACTLY the same requirement.
    Exact same requirement HERE...

    Please Login or Register  to view this content.
    Last edited by Sintek; 02-14-2025 at 10:42 AM.

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

    Re: detect in the blue line the numbers that were drawn correspondingly.

    Hello Sintek, thank you for your work in Excel. Learning Excel takes more than years to master, and even then you can't do certain formulas. I'm a truck driver, John. Mathematicians and statisticians don't win the lottery. Why do they think that Excel tracking is pure juggling? I think differently. The difference from random is that in random, the numbers take up the entire board. And with frequency and repetition statistics, you can find hot and cold zones or sectors by filtering the empty spaces on the board. These empty spaces at the intersection of the non-Cartesian row and column of the board make the bettor lose. Okay, you have to have a dose of luck, like Pareto 80/20.

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,679

    Re: detect in the blue line the numbers that were drawn correspondingly.

    You can manipulate the numbers in any way you like but you will not increase your of chances of winning: whether you accept this or not ... that is your call. QED.

+ 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] detect in the blue list how many times each formation was drawn from the list next to it.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-03-2024, 08:42 PM
  2. detect in each separate quadrant the numbers that have not yet been drawn.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2022, 09:03 AM
  3. detect the number of times each line was drawn.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2021, 11:25 AM
  4. detect in the yellow group the number of numbers drawn.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2020, 08:44 AM
  5. Blue Line NEXT TO row numbers
    By HVAF in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2020, 12:29 PM
  6. detect the number of numbers drawn from times of each letter in the 4 blocks
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-25-2020, 03:26 AM
  7. Replies: 0
    Last Post: 02-17-2020, 02:13 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