# pattern and shift in even and odd lottery

#### excelguy1234

##### New Member
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

### 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
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.

Replies
6
Views
74
Replies
3
Views
115
Replies
2
Views
45
Replies
1
Views
19
Replies
6
Views
156