+ Reply to Thread
Results 1 to 10 of 10

Excel and using it for the Euro millions lottery

  1. #1
    Registered User
    Join Date
    12-18-2011
    Location
    Liverpool,england
    MS-Off Ver
    Excel 2010
    Posts
    21

    Excel and using it for the Euro millions lottery

    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

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel and using it for the Euro millions lottery

    no but i've just knocked one up
    Attached Files Attached Files
    "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

  3. #3
    Registered User
    Join Date
    12-18-2011
    Location
    Liverpool,england
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Excel and using it for the Euro millions lottery

    Brilliant,
    Thanks very much. Just what i needed

  4. #4
    Registered User
    Join Date
    08-14-2013
    Location
    Hampshire,England
    MS-Off Ver
    Excel 2011
    Posts
    3

    Smile Re: Excel and using it for the Euro millions lottery

    Quote Originally Posted by martindwilson View Post
    no but i've just knocked one up
    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.

  5. #5
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Excel and using it for the Euro millions lottery

    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,

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel and using it for the Euro millions lottery

    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
    Attached Files Attached Files
    Last edited by martindwilson; 08-15-2013 at 09:08 AM.

  7. #7
    Registered User
    Join Date
    08-14-2013
    Location
    Hampshire,England
    MS-Off Ver
    Excel 2011
    Posts
    3

    Smile Re: Excel and using it for the Euro millions lottery

    Quote Originally Posted by martindwilson View Post
    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
    Hi Martin, thank you for the UK Lotto, much appreciated. You mention about the 0 numbers & 2 stars being added in as a No Win, how do you do this? Pardon my ignorance, have no idea. Grateful for your assistance.

    Cheers,

    Rhino

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel and using it for the Euro millions lottery

    i did it anyway

  9. #9
    Registered User
    Join Date
    08-07-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel and using it for the Euro millions lottery

    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.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    08-14-2013
    Location
    Hampshire,England
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Excel and using it for the Euro millions lottery

    Hi, do you have anything available for checking thunder-ball?
    Would be of great assistance if you have.

    Many thanks.

    Rhino55

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1