Markus is looking for Excel help to pick numbers for the Euro Jackpot where you have to choose 5 numbers from 1 to 50. In this video, I share secrets from my late friend Dogtrack Bill.

To use the number picker in a free Excel Online, follow this link:
https://1drv.ms/x/s!As7G72Sl487JljvjcWPxwg0_pTe1?e=CMGO1E

The Euro Jackpot payout for matching 5 numbers with no bonus numbers is a parimutuel system. A fixed percentage of the betting pool is split between all people that matched five numbers. To maximize the payout if you win, choose numbers that are not likely to be chosen by other people. Avoid drawing patterns on the betting card. And, most importantly, stop using dates to choose your lottery numbers.

Table of Contents
(0:00) Markus asks for Euro Jackpot 5/50 advice
(0:20) Formulas require latest Excel
(0:42) Movie: Jerry & Marge Go Large
(1:02) Dogtrack Bill
(1:19) Strategy for parimutiel betting
(2:05) Don’t draw patterns on lottery betting slip
(2:50) Don’t choose Dates
(5:12) Mix of high & low, odd & even
(5:58) Excel formulas to randomize picks
(6:28) How many numbers are Odd using Excel
(6:48) Avoid date picks
(7:20) Conditional formatting for green
(7:49) Choose 2 numbers from 1-10
(8:00) YouTube description won’t allow less than symbol
(8:26) Explanation of all Excel Formulas
(9:42) Sort numbers so it is easier to mark the card
(9:55) Maximize the parimutuel winnings
(10:26) Thanks

Formulas used in the spreadsheet:
B3: =SORT(VSTACK(INDEX(SORTBY(SEQUENCE(25),
RANDARRAY(25)),SEQUENCE(3)),
INDEX(SORTBY(SEQUENCE(25)+25,RANDARRAY(25)),SEQUENCE(2))))
D3: =SUM(–ISODD(–B3#))
F2: =OR(D3=2,D3=3)
F3: =MAX(B3#)GT31
F4: =AND(F2:F3)
H3: =SORT(INDEX(SORTBY(SEQUENCE(10),
RANDARRAY(10)),SEQUENCE(2)))