how do i use excel to check my lottery numbers

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

Should be possible. Look at the countif worksheet function.

--
Regards,
Tom Ogilvy

"pat07734" <[email protected]> wrote in message
news:[email protected]...
> I was just trying to use an excel sreadsheet to sort my lottery numbers,
> highlight matches and see if I have won anything.

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
[email protected]
"pat07734" <[email protected]> wrote in message
news:[email protected]...
> I was just trying to use an excel sreadsheet to sort my lottery numbers,
> highlight matches and see if I have won anything.

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

--
Don Guillett
SalesAid Software
[email protected]
"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]
> "pat07734" <[email protected]> wrote in message
> news:[email protected]...
> > I was just trying to use an excel sreadsheet to sort my lottery numbers,
> > highlight matches and see if I have won anything.
>
>

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

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

pat07734 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html