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
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
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.
ok but for someone who has never made a macro it is an impossible task
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?!
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!!!
If it could be done using statistics, there would be many milionaire statisticians!Remember, the reason for all his posts is merely to win the lotto...![]()
hello,sintek
As per John...
Exact same requirement HERE...you have had numerous example of EXACTLY the same requirement.
![]()
Please Login or Register to view this content.
Last edited by Sintek; 02-14-2025 at 10:42 AM.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks