Hello,
Does any user in the UK have a excel spreadsheet that they use to check euro millions lottery draws? I'm seting up a 28 member syndicate and would like excel to check if we have any winning lines?
Thanks
Andy
Hello,
Does any user in the UK have a excel spreadsheet that they use to check euro millions lottery draws? I'm seting up a 28 member syndicate and would like excel to check if we have any winning lines?
Thanks
Andy
no but i've just knocked one up
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Brilliant,
Thanks very much. Just what i needed
Hi Martin,
What a brilliant bit of ingenuity in compiling this Euro Checker, have been after something like this for ages, saw this on google search and registered for the download, so glad I did.
I don't suppose you have something similar for the normal lottery do you?
Wish I had the ability to do something like this in Excel.
Many thanks Martin.
I have attached a spreadsheet I use for checking my numbers in a 6/49 lotto (that is one has to choose 6 numbers from a possible 49 - get the correct 6 numbers and life changes!!!)
Explanation: In the range B2:G7 to enter each of my 6 numbers per row and in Row 8 I enter the numbers that came up on the draw - any numbers that are in the draw and on my ticket will be highlighted - 3 or more and I've won something! The other number in row 10 and down show which of the 40 numbers I have actually chosen.
LOTO - 6-49 - Example.xlsx
I do have another which records all the winning numbers for the past year and this shows which numbers come up more than others - quite an eye-opener really because some numbers definitely do appear regularly!
Cheers,
i just noticed i'd missed 0 numbers 2 stars so that should be added in as no win for euro and i,ve added a uk version as well
Last edited by martindwilson; 08-15-2013 at 09:08 AM.
i did it anyway
I created this a little while ago. Your post was still open, thought you may want it.
This allows you to check the draw history of up to 99 weeks.
Hi, do you have anything available for checking thunder-ball?
Would be of great assistance if you have.
Many thanks.
Rhino55
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks