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

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
.

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 siteright click to download to excelrefresh 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

"Tigerman" wrote in message
...
How do I get excel to check my list of lottery numbers for any possible
wins