I'm sorry but I haven't bought a lottery ticket in over 15 years.
Maybe, if you share how the odds are printed on the ticket and how that
relates to the dollar amount someone, if not me, will be able to tell
you how to reorganize the information in the form you want.
That said, I should point out that given the number of people who play
all the different lotteries, if there was any variation in the
probability of winning a particular amount it would have been
identified by now. And, thanks to the Internet, dissemination of that
information would not take long. But, hey, anything's possible... {g}
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions