Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
How to make this plot? | Charts and Charting in Excel |