Results 1 to 7 of 7
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Lottery Tickets (XP)

    I'm in a large pool of lottery players, and I'm the guy who has to check the tickets to see if we have any winners. We will be playing for 25 weeks, each week playing the numbers in the attached file. I want to automate the process of finding and counting the number of matches between my tickets and the winning numbers. I've programmed stuff like this before, but not in Excel.

    Each week, five numbers are drawn, plus a sixth, the "Powerball." I want to enter these numbers in six cells somewhere on the worksheet, then have Excel find the matches in my array of tickets. (The rows on the worksheet are the numbers on each ticket.) A match on the Powerball is special, and needs to be noted. Matches on the other five numbers need to be highlighted, and preferably counted for each ticket.

    If the matches are noted and counted for each ticket, I can take it manually from there.

    Who can get me started?
    Attached Files Attached Files
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lottery Tickets (XP)

    Hi Lou

    I remember Hans and Steve showing some excellent examples for the UK lottery, 6 balls + 1 bonus ball, the posts started at <post#=514340>post 514340</post#> , but I think the atachment suffered in the 'Big One' a few months back, I am pretty positive I have a copy on a disk at work and will post in a couple of hours if I can find it.

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lottery Tickets (XP)

    Hi Lou

    I had it on a disc at home, perhaps you can convert this to your own needs

    Cheers

    Steve
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Lottery Tickets (XP)

    Got it! Thanks. I'll take a look right now.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  5. #5
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Lottery Tickets (XP)

    I've looked at it now. Our lottery scheme is different. We draw five balls, and the sixth is a separate "bonus ball."

    I'm thinking I can adapt what you sent, though.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  6. #6
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Lottery Tickets (XP)

    I've adapted the spreadsheet to the Powerball lottery. Couldn't have done it without you. Thanks!

    If there is any interest, I can un-customize it and post it up here.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lottery Tickets (XP)

    I don't voluntarily give any of my money to the government so it would not help me! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

Posting Permissions

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