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" wrote in message
...
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

"pat07734" wrote in message
...
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

"Don Guillett" wrote in message
...
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

"pat07734" wrote in message
...
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 he

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