How do I make a lottery checker

[Tigerman]

How do I get excel to check my list of lottery numbers for any possible wins

[Biff]

Hi!

Post back with a good email address and I'll send you one.

Biff

>-----Original Message-----
>How do I get excel to check my list of lottery numbers
for any possible wins
>.
>

[Don Guillett]

I have done one for Texas & mega.

Set up a query table to the url > design a macro to text to columns the
numbers>
OR
goto the site>right click to download to excel>refresh from there for the
tables you want

a macro to check the numbers against yours.
Use conditional formatting to check your numbers against the winning numbers
Use a formula and conditional formatting to count yours and lookup your
winnings, IF any.
=sumproduct((yournumbers=a winning number)*1)
to count the winners
=IF(F6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
--
Don Guillett
SalesAid Software
[email protected]
"Tigerman" <[email protected]> wrote in message
news:[email protected]...
> How do I get excel to check my list of lottery numbers for any possible
wins

[orangeanorak]

Check here www.thelotterychecker.com