Lotto Number Checker

[clash]

Please help.

I have to check 30 Lotto tickets ever week and have tried (and failed
to come up with a way over putting all the selected tickets in a grid
and having another grid with that weeks numbers in. Then finding a "IF
statement to highlight each of the current weeks numbers on the firs
grid, therefore showing how many numbers on each ticket.

Your help would be invaluable

 

[Sandy Mann]

With the selected ticket numbers in A1:F30 and the winning numbers in H1:M1
then highlight all selected ticket cells and use Conditional Formatting with
the formula:

=COUNTIF($H$1:$M$1,A1)>0

To count the winning numbers enter:

=COUNTIF(A1:F1,$H$1)+COUNTIF(A1:F1,$I$1)+COUNTIF(A1:F1,$J$1)+COUNTIF(A1:F1,$K$1)+COUNTIF(A1:F1,$L$1)+COUNTIF(A1:F1,$M$1)

in G1 and copy down.


--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Biff]

Hi!

I have a file that does this. It has a sheet for pick 5 and one for pick 6.

When you say: "I have to check 30 Lotto tickets", does that mean you have 30
sets of numbers, one set per ticket?

My file is for "heavy" lottery players. It is setup to check up to 250 sets
of numbers. Usually, if you want 250 lottery tickets you get 50 tickets with
each having 5 sets of numbers. That's how my file is setup. It's ideal for
lottery pools that play the same sets of numbers every week. You enter the
sets once then enter the numbers when they're drawn. Any matches are
highlighted and counted.

If you want a copy just let me know where to send it.

Biff

 

[Sandy Mann]

With all these Lotto checkers around - "this time next year we'll be
millionaitres!" <g>