lottery bingo keep track of all week numbers leading up to the winner

[mark2966]

Hi I run a lottery bingo syndicate at work there are 45 people who pick 6 numbers and when the main numbers are drawn except bonus ball they are compared and when they have all there numbers drawn the person who eventually gets all there 6 numbers they win I would like to keep track of all weeks numbers leading up to the winner. please help

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Ursul]

How many numbers are in the lottery? Are there 45 numbers or 49 ....?

[mtouhig]

Hi . I run a similar thing for my local pub. But we only count the bonus ball drawn on a Saturday. There are over 100 members and the last game ran for 36 weeks and winner got nearly £4000. All I need to do is enter the amount paid by the player into the correct cell (date) - and the ball drawn of course. If a player falls over 2 weeks behind their list is formatted in grey. If you look at the enclosed sheet, the weeks in hand column is just a total of the players amount paid minus the week number (calculated automatically from the system clock.)

You may get some ideas from this. Please let me know if this helps, via replying to this thread.
Mark, Nottingham

[orangeanorak]

Hi if you still want this, I do these for loads of people - see my webpage and get in touch if still interested www.thelotterychecker.com