Checking Winning Numbers in the Lottery.

```For people who may not understand the lottery rules for the UK.

Person picks 6 numbers in the range 1 to 49 (no duplicates)

If all the 6 numbers come up then when the lottery numbers are announced,
then it is serious party time.

Problem: -

We have 25 people in our Lottery syndicate and therefore I want to automate
the checking of numbers that are announced with numbers that are pre-selected
by the 25 individuals. Additionally, I want to know how many numbers have
matched in an individual row against those announced.

E.G.

Assume lottery number announced (in ascending sequence are) 1, 15, 25, 38,
48, 49

Pre-selected numbers are:-

Person A 4, 15, 20, 28, 35 49

Person B 1, 15, 25, 38, 47, 48.

Person C 6, 15, 25, 38, 41, 49

I would expect a match count of 2 for person A (15 and 49)

I would expect a match count of 5 for person B (1, 15, 25, 38, 48)

I would expect a match count of 4 for person C (15, 25, 38, 49)

I currently have the pre-selected numbers in a spreadsheet and I would just
want to key in the announced numbers in for it to work things out.

Any help would be appreciated.

--
Thanks

Ann
```
 0
Ann (124)
5/18/2005 7:28:02 AM
excel.misc 78881 articles. 5 followers.

4 Replies
264 Views

Similar Articles

[PageSpeed] 58

```One way ..

Assuming the winning numbers will be entered in A1:F1 in Sheet1, for
example: 1, 15, 25, 38, 48, 49

(The numbers within A1:F1 need not be sorted, can be in any order)

And the picked #s are in Sheet2, in cols B to G, row1 down

4 15 20 28 35 49
1 15 25 38 47 48
6 15 25 38 41 49
etc

(as before, the numbers within each row need not be sorted)

Put in say, I1:

=SUMPRODUCT(--ISNUMBER(MATCH(B1:G1,Sheet1!\$A\$1:\$F\$1,0)))

Copy I1 down

Col I will return the desired # of matched numbers

For the sample data, you'll get in I1:I3   :   2, 5, 4

--
Rgds
Max
xl 97
---
GMT+8,  1� 22' N  103� 45' E
xdemechanik <at>yahoo<dot>com
----
"Ann" <Ann@discussions.microsoft.com> wrote in message
news:DC48199D-98D6-4BBD-B12D-E5A9EC410636@microsoft.com...
> For people who may not understand the lottery rules for the UK.
>
> Person picks 6 numbers in the range 1 to 49 (no duplicates)
>
> If all the 6 numbers come up then when the lottery numbers are announced,
> then it is serious party time.
>
> Problem: -
>
> We have 25 people in our Lottery syndicate and therefore I want to
automate
> the checking of numbers that are announced with numbers that are
pre-selected
> by the 25 individuals. Additionally, I want to know how many numbers have
> matched in an individual row against those announced.
>
> E.G.
>
> Assume lottery number announced (in ascending sequence are) 1, 15, 25, 38,
> 48, 49
>
> Pre-selected numbers are:-
>
> Person A 4, 15, 20, 28, 35 49
>
> Person B 1, 15, 25, 38, 47, 48.
>
> Person C 6, 15, 25, 38, 41, 49
>
> I would expect a match count of 2 for person A (15 and 49)
>
> I would expect a match count of 5 for person B (1, 15, 25, 38, 48)
>
> I would expect a match count of 4 for person C (15, 25, 38, 49)
>
> I currently have the pre-selected numbers in a spreadsheet and I would
just
> want to key in the announced numbers in for it to work things out.
>
> Any help would be appreciated.
>
> --
> Thanks
>
> Ann

```
 0
demechanik (4694)
5/18/2005 9:12:20 AM
```Since the winning numbers within A1:F1 in Sheet1 need not be sorted (can be
in any order), the winning numbers can actually be input as they are
progressively drawn/announced into the range from A1 to F1.  Sheet2's col I
will then display the progressive calculated number of matches for each row.
--
Rgds
Max
xl 97
---
GMT+8,  1� 22' N  103� 45' E
xdemechanik <at>yahoo<dot>com
----

```
 0
demechanik (4694)
5/18/2005 9:37:41 AM
```Max,

What can I apart from WOW and many thanks for you time.

I am new to these newsgroups and will be frequenting often if this is the
standard of help being offered.

Once again many thanks.

"Max" wrote:

> Since the winning numbers within A1:F1 in Sheet1 need not be sorted (can be
> in any order), the winning numbers can actually be input as they are
> progressively drawn/announced into the range from A1 to F1.  Sheet2's col I
> will then display the progressive calculated number of matches for each row.
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8,  1° 22' N  103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
>
```
 0
Ann (124)
5/18/2005 9:50:02 AM
```You're welcome, Ann !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8,  1� 22' N  103� 45' E
xdemechanik <at>yahoo<dot>com
----
"Ann" <Ann@discussions.microsoft.com> wrote in message
news:EDB17EE1-33FA-4FB7-83EC-B40A6F267B64@microsoft.com...
> Max,
>
> What can I apart from WOW and many thanks for you time.
>
> I am new to these newsgroups and will be frequenting often if this is the
> standard of help being offered.
>
> Once again many thanks.

```
 0
demechanik (4694)
5/18/2005 9:55:33 AM

Similar Artilces:

How do I set number formats that will be applied only if a number.
Hi you may post your question as body of your message :-) -- Regards Frank Kabel Frankfurt, Germany "Jim Gentile" <JimGentile@discussions.microsoft.com> schrieb im Newsbeitrag news:2678B459-1954-4258-A570-155E25F18F52@microsoft.com... > ...

merge MSN Bill Pay & Checking Acct
I want to merge my checking account with MSN Bill Pay but only see that I can merge MSN Bill Pay with my checking account (i.e., you lose all of your checking account information). Does any one have any suggestions? -- cheers, Tom G ...

How can i change value of number to zero, when i have
How can i change value of number to zero, when i have 00000.000 "" formula rezult? For example A1=00000.000 "E" A2=00000.000 "E" The SUM value of A1 and A2 is 00000.000 "", but I need that rezult would display like 0 "" if there is no whole numbers in A1 and A2. Thanks for helping :) Have you tried using the format cell option. r-click -> Format Cells -> Number tab -> select Number in the window and you can specify the decimal places, and there are custom options as well. I'm not a guru, but if it works, i...

Check names not working for multiple address books / contacts
Hello! I have upgraded from outlook 2003 to outlook 2007, my contacts are stored in pst. I used to be able to search for a name via check names and it displayed me all the results from global address list and from my contacts, but now it only does one. It does not matter which one I set in the checking order, whichever is top will be the one that provides the result. I would like it to show me both results, how would I go about to set that up? Thank you Deana More accurate and complete information would be helpful. The Global Address List is only available to those who c...

Authorizing checks with RMS
I recently removed PCCharge and setup my syetm to work with a preferred merchant provider to allow native processing of credit & debit cards. Since check verification/authorization was handled by PCCharge to Telecheck, check authorization is now not being done. How is check authorization accomplished using a preferred provider? Thanks, Richard Unfortunately, it's not. PC Charge is the only option for check processing in RMS as far as I know. TPI or some other vendor may support it through an add-in, but RMS as shipped has no way of doing both checks and debit... -- -- Gle...

How do I create Check list
1.I am new to excel and want to create a simple check list. I would like to have the first column check boxes and then the following columns discription and notes. Can someone give me a step by step on how to do this. I have created spread sheets but am not familiar with check boxes. 2.Also, Can someone tell me the difference between Access and Excel? Geek 1) Not sure what you're aiming to do with the checkboxes, but if you right click on the toolbar area, you will get a list of available toolbars. You want either the 'forms' toolbox or the 'controls' toolbox. Genera...

Building an Embedded Device/System? Tell VDC about your experience for a chance to WIN!
VDC is conducting its annual survey of mobile and embedded engineers so if you are involved in the engineering of mobile or embedded systems/software, this is your chance to influence key solution suppliers. The research covers embedded software, hardware, tools, and development practices. Your thoughts will improve our insights into the engineering community and help to influence next generation solutions. In addition, VDC will provide all respondents who complete the survey: * Instant access to a summary of VDC's 2009 survey findings; * Entry into a prize drawing for one...

Summation of 3 biggest numbers... #2
hi all, is there any quick method to add up 3 biggest numbers in a se of number? e.g. I have the following data in a row: 100 20 90 30 And I want to add up 3 biggest numbers, i.e. 100 + 90 + 30 = 220 Thanks -- lau000 ----------------------------------------------------------------------- lau0001's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3332 View this thread: http://www.excelforum.com/showthread.php?threadid=53144 thanks all, I have solved the problem by "large" function.:) -- lau0001 -----------------------------------------------------...

Preventing multiple check boxes from being checked
I have a worksheet with over 20 rows of check boxes with 5 check boxes in each row. (from the forms toolbox) I would like to prevent the user from checking more than one box in each row. Is this possible? BTW, this forum has been a great help. I'm so glad that expert Excel users are so willing to share their wealth of knowledge. Thanks again. Jae Put them in a group box, again from the forms toolbar. Drag the group box onto the sheet, then drag the checkboxes in. -- HTH RP (remove nothere from the email address if mailing direct) "Jae" <Jae@discussions.micro...

Check text field value against underlying table or query of combo box
Hello, I have a form on which the user can enter new records or update existing ones. If the user enters a new record on the form, I would like to have an 'After Update' event on one of the text fields, which is the item# to check if the value entered already exists in the underlying table, tbl_item. How can I call the table from the 'After Update' event of the text field and check for that value in the table? Thanks in advance. Regards, A. Crawford antcraw@swbell.net wrote: >I have a form on which the user can enter new records or update >existing ones. >If the us...

Printing Checks
I'm having a problem printing checks from Money 2003. I have three accounts that come up in one .mny file. Two of the accounts use 3-on-a-page checks and I want the name and address printed on them. One account uses voucher checks and needs to be nudged a little south. When I go to print checks I have to be aware of what account I'm in and change the settings by hand to make sure the checks print correctly. How can I make the check-print settings stick with the account I'm using. It's a pain to have to remember every time. I'm frequently forgetting and screwing up a pag...

Employee Check Format-Graphical
Does anyone know of a TK that shows how to convert one of the employee check from a text report to a graphical report? We do not have Direct deposit, I looked in the Report Downloads from Great Plains and did not see one there either. thanks -- Doug There's no secret here. Just un-check the "Text Report" option in the Report Definition window. And then modify the report so it looks like you want it. This will take some time. The reports don't transfer from text to graphical nicely. "Doug" wrote: > Does anyone know of a TK that shows how to convert...

Check Names = "Exchange Server computer is busy..."
Here's what I got: Active Directory on Server 2003 1 Domain Controller also running DNS and WINS No other DNS or WINS servers (I know, I know) Static IP Addresses...NO DHCP Exchange Server 2003 on a member server Client running W2K SP4 Outlook 2000 SP3 Exchange has 4 mailboxes set, but nobody is using it. I'm still testing things out. When I try to connect to Exchange via my Outlook 2000, I get the following message: "The function cannot be performed because the Microsoft Exchange Server computer is busy. Try again later" I've tried it from 3 different client comp...

Document numbering in Excel
Please help! I need to know how to put in a formula for the follwing. I created delivery notes on Excel. In the one cell I need to put a formula in order to bring up a new page number for every new delivery note I do. This I must do the same for collection notes and invoices. I need this really urgently. Thank you so much. -- Rykie Botha Hi, look into McGimpsey web http://www.mcgimpsey.com/excel/udfs/sequentialnums.html if this helps please click yes thanks "Rykie" wrote: > Please help! I need to know how to put in a formula for the follwing. ...

Printing MICR checks
Hello, We are having an issue printing checks on the Select Payables Checks window. When we try to print the checks we receive the error message below: "Warning: You have MICR but are not in a MICR screen. To use MICR, abort this screen and set up security access." The user has access to this screen but I'm not sure what this error message means. There was nothing related to this in the Knowledge Base either. Has anyone else received this error message before and if so how did/do you resolve it? Thanks! The user has the third party mekorma check writing module ...

Check off boxes
Publisher 2003 in use. I am creating a questionnaire that will be included in a newsletter. I am using the publisher software to make this form. Somewhere, in the past, I saw a keyboard shortcut to inset checkoff boxes, however, I cannot remember the key strokes. Any help along this line will be greatly appreciated. Thank you and enjoy your day. Mike Mike Reshetar wrote: > Somewhere, in the past, I saw a keyboard shortcut to inset checkoff boxes, > however, I cannot remember the key strokes. Use Wingdings and the � or q characters. -- Ed Bennett - MVP Microsoft Publisher h...

check check check
afpoiadshfpaosid It is a feature, not a bug -- Message posted from http://www.ExcelForum.com ...

spam properties check
When I receive a suspecious email (spam), I right click, without opening the message, to check the properties to make sure it is spam before I forward to the "missed spam" software of my ISP. Some spam emails then ask me if "I want to save the changes" before I close the properties box. I am then not able to forward this email without replying yes to "save the changes?" I did not make any changes, I just checked the properties. Why is this happening? ...

in excel why do numbers entered get divided by 100?
Excel was working fine last time I used it, but now if I type in for instance 5000, it puts 50 in the cell and on the formula bar, and calculates etc. as 50. I have tried changing formatting, but this doesn't make any differnce In Excel, click on Tools | Options | Edit | uncheck the "Fixed decimal places" box | OK. "roger bemused" wrote: > Excel was working fine last time I used it, but now if I type in for instance > 5000, it puts 50 in the cell and on the formula bar, and calculates etc. as > 50. I have tried changing formatting, but this doesn't...

tristate check box #2
I have a tristate check box.The default behavour of tristate check box in windows is that, the grayed check box will become unchecked after click on grayed check box. But i want , the grayed check box will become checked after click on grayed check box in VC++ .Pls help me its urgent. Well, for Win32, you can always SendMessage the button a BM_GETSTATE. I'm sure with MFC there's a function that will permit this; it could be as simple as button_name.GetState(). Well, for the event OnClick for that button, you can get the state of the button and then either run it through some if-...