pattern and shift in even and odd lottery

excelguy1234

New Member
Joined
Feb 17, 2019
Messages
1
Hello,
Trying to found away to find next pattern or shift change using excel. please see below.

E-E-O-O-E
E-E-O-E-E
O-O-E-E-E
E-O-E-O-O
E-E-E-O-O
E-E-O-O-O
O-O-E-O-O
E-O-E-E-O
O-E-O-O-O
E-O-E-E-E
E-E-E-E-O
O-E-O-E-O
E-O-E-O-E
O-E-E-O-O
O-E-O-O-E
E-O-O-E-O
O-O-E-E-O
E-O-O-O-E
O-E-E-O-E
O-O-O-O-O
O-E-E-E-O
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Drrellik

Well-known Member
Joined
Apr 29, 2013
Messages
768
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2011
  5. 2010
Platform
  1. Windows
If you are working on a spreadsheet for guessing lottery numbers, it seems like you approach is; will the next number be odd or even? that only cuts your 'chances' in half you might want to look at likelihood of a range of numbers for the 'first' (lowest) ball, then 2nd, then 3rd, we already know that the 3rd number can not be a 2 and the chances of the 4th and 5th balls being 4 & 5 are very unlikely generally speaking the 5th number is usually 55+ and the first number is <15 I would think you look for patterns and probabilities in a range of numbers before you would just look for odd or even.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,468
Members
409,883
Latest member
asharris90
Top