how do i use excel to check my lottery numbers

[Guest]

I was just trying to use an excel sreadsheet to sort my lottery numbers,
highlight matches and see if I have won anything.

 

[Tom Ogilvy]

Should be possible. Look at the countif worksheet function.

 

[Don Guillett]

sort
[a4:e4].Sort Key1:=[a4], Orientation:=xlLeftToRight
hightlight matches with conditional formating
=sumproduct(($b$5:$f$5-e10(=)*1)
to count em up
=IF(G6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
conditional formatting to turn red if >2

 

[Don Guillett]

=sumproduct(($b$5:$f$5-e10(=)*1)
type

=sumproduct(($b$5:$f$5=e10)*1)

--
Don Guillett
SalesAid Software
(e-mail address removed)

sort
[a4:e4].Sort Key1:=[a4], Orientation:=xlLeftToRight
hightlight matches with conditional formating
=sumproduct(($b$5:$f$5-e10(=)*1)
to count em up
=IF(G6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
conditional formatting to turn red if >2

--
Don Guillett
SalesAid Software
(e-mail address removed)

I was just trying to use an excel sreadsheet to sort my lottery numbers,
highlight matches and see if I have won anything.

 

[Debra Dalgleish]

You can use conditional formatting to highlight the numbers, as shown here:

http://www.contextures.com/xlCondFormat03.html#Lottery

 

[freeexcelapps]

Anyone stumbling across this old thread.... I have built a quick Excel App to check your lotto numbers.... FREE to use... have a go...

I can't paste a link here, but ping me if you would like the link... it can check up to 100 lines, for tues/Wed lotto with ease.