Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 a- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
complex validation for lottery numbers | Excel Discussion (Misc queries) |