lottery # finder

[Bill]

I am responsible for numerous tickets purchased by friends. The effort is
to create a sheet where I will put in their numbers, and then when the
lottery is drawn, put in the winning numbers and instantly see how many
match. For instance, if the first number on the winning row is 20, I would
like to see quickly how many had 20 no matter what row their's was in. etc.
etc.
This would make it much easier to locate those who have won prizes other
than the total amount. I have been trying to use the LOOKUP formula
matching their numbers with the top column, but when there is no match I get
a /ref error which clutters up the sheet. Is there a better formula to use
to get a quick clean match between a specific ticket number and any number
in the first row?

 

[T. Valko]

Here's a sample file that does what you want:

Ticket Checker.xls 84kb

http://cjoint.com/?mqi1Ti1NrO

This file contains a simple macro to clear the range.

It's protected but there is no password used.

It has a sheet for pick 5 and pick 6.

It will handle up to 250 lines of numbers.

It also uses data validation so you won't make a mistake in entering an
invalid number.

 

[Bill]

Thanks a lot...I will give it a try. And good luck on any lotteries you
try.

 

[T. Valko]

You're welcome.

It probably isn't exactly what you had in mind but you can at least see the
formulas I used to count matches and the conditional formatting I used to
highlight matches.