|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 17th 05, 05:28 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
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. 
|
| Ads |
|
#2
April 17th 05, 05:55 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i use excel to check my lottery numbers
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.
|
|
#3
April 17th 05, 06:10 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i use excel to check my lottery numbers
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.
|
|
#5
April 17th 05, 07:02 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i use excel to check my lottery numbers
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| check against a lottery database | PAULGOR | Excel Discussion (Misc queries) | 6 | December 8th 09 09:04 PM |
| Is there a template to double check Lottery scratcher tickets? | lkn4bearbud | Excel Discussion (Misc queries) | 1 | April 18th 09 08:08 AM |
| Lottery check | Ron | New Users to Excel | 13 | September 15th 06 02:13 AM |
| How do I generate random lottery numbers in Excel? | Mark1809 | Excel Worksheet Functions | 7 | July 31st 05 07:23 PM |
| combination of numbers in lottery | knoertje[_6_] | Excel Programming | 32 | October 12th 04 07:05 PM |
Linear Mode
