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 first grid, therefore showing how many numbers on each ticket.

Your help would be invaluable.

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(A 1: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

Replace@mailinator with @tiscali.co.uk


"clash" wrote in message
...

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 first
grid, therefore showing how many numbers on each ticket.

Your help would be invaluable.


--
clash

"clash" wrote:


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 first
grid, therefore showing how many numbers on each ticket.

I wrote a lottery checker some years ago. Contact me at
and I'll send it to you.

Regards
Peter

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

"clash" wrote in message
...

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 first
grid, therefore showing how many numbers on each ticket.

Your help would be invaluable.


--
clash

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

--
Sandy

Replace@mailinator with @tiscali.co.uk

Thanks for all your help !!

this is going to save alot of time.

Clash.

Perhaps you could use Conditional Formatting?
For a six number lottery, put the winning numbers into B1:G1.
Then, Select the cell range where the numbers on your tickets are entered.
Go to Format | Conditional Format and change the Condition drop-down to
Formula is. Enter this formula:
=OR(B9=$B$1,B9=$C$1,B9=$D$1,B9=$E$1,B9=$F$1,B9=$G$ 1)
Then, set your formatting. When a number in the grid matches a winning
number, it will change formatting to match what you set.

--
tj


"clash" wrote:


clash Wrote:
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 first
grid, therefore showing how many numbers on each ticket.

Your help would be invaluable.



Thanks for all your help !!

this is going to save alot of time.

Clash.


--
clash

Contact me I will send you excel file, which I created for my self
slaw