Lottery Bingo Style Template

**giraffe1ton** · 11-26-2012, 07:58 AM

Hi, I am new to this forum and new to excel spreadsheets.
I run a bingo style lottery sweep at work and spend too much time checking numbers etc and was hoping to find a a simple spead sheet template I could use to help speed up the process and eliminate any human errors.
The system is based on the six numbers drawn on saturdays lottery excluding the bonus ball.

Does anyone know of such a solution?

Regards

**martindwilson** · 11-26-2012, 08:21 AM

maybe something using conditional format like this

**giraffe1ton** · 11-27-2012, 10:28 AM

Hi,
Many thanks for your reply, just the job.
Regards

S

**GuillermoKnomatez** · 05-01-2014, 01:52 AM

Thank you for this - been looking for something like this for ages

**GuillermoKnomatez** · 05-01-2014, 02:58 AM

Made a few tweaks to suit my particular reqs - changed conditional format from COUNTIF($B$2:$H$2,$Sheet1.C14) - Single line 2, to:

COUNTIF($C$2:$H$10,$Sheet1.C14)- Range of lines 2 to 10 and inserted column.

Hope you like.Lotto Bingo.xls

**zbor** · 05-01-2014, 03:00 AM

GuillermoKnomatez,
this is 2 years old thread. I doubt he still watchin it.
Rather help people who asking for help right now

**GuillermoKnomatez** · 05-04-2014, 01:25 PM

Posted here because here is where I found what I needed.
Rather post replies to interested people rather than xxxxx xxxxx xxx xxxxxxxxx xxxx xx xxxxxxx.

**broncodelivery** · 01-03-2023, 02:20 PM

does anyone know how to fix a sheet that has the macro locked?

**Glenn Kennedy** · 01-03-2023, 02:22 PM

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.

Also... what did your query have to do with the original?? It sound totally unrelated.

THREAD CLOSED.