Lottery 1st & 2nd Digits Calculations

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Need help with creating 2 lists:
Example: 5/39 Lottery Game
List #1 - 1st digits/left digits
Pad all numbers with a zero in numbers less than 10 (01-02-03-04-05)
Create a list of all 1st or left digit sets
01-02-03-04-05 = 0,0,0,0,0
35-36-37-38-39 = 3,3,3,3,3
Count how many sets from the entire list of 575757 have the 1st digits 0-0-0-0-0 through 3-3-3-3-3
Remove any duplicate 1st digit sets from the list

List #2 - 2nd digits/right digits
Pad all numbers with a zero in numbers less than 10 (01-02-03-04-05)
Create a list of all 2nd or right d1,2,3,4,5
35-36-37-38-39 = 5,6,7,8,9
Count how many sets from the entire list of 575757 have the 2nd digits 1,2,3,4,5 through 5,6,7,8,9
Remove any duplicate 2nd digit sets from the list.

Thank you in advance.
 
Stephen,
Thank you for the additional information.
Very much appreciated.
I will explore the information presented tomorrow.
 
Upvote 0

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Stephen,
Can you check the following?
Cell B1 enter the value 30
Cell C1 enter the value 5
Cell B2 select Last

Cell range A20 through E20
Cell C20 can not be a 0 or 30

I went the long route of creating all 142,506 sets, split these into 2 columns. 1st digit column and a 2nd digit column.

The First calculation is totally correct

The Last calculation should have a total of 67,506 possible 2nd digit sets for a 5/30 game.

Would it be possible to check the code to see if any errors?

Thank you so much!!

Steve
 
Upvote 0
How did you get 67,506?

For all possible 2nd digit sets, the total number of combinations is 142,506, i.e. COMBIN(30,5) as is required.

From 1|2|3|4|5 to 5|6|7|8|9 inclusive is 70,422 combinations.

If this corresponds to your 67,506, it looks like you're missing a few.

If you line up yours and mine, you should be able to identify which ones?
 
Upvote 0
My workbook shows that for 5/30, there are 1,902 last digit combinations - 2,002 shown less 100 #NUM values because the digit combination is not possible, e.g. we can't have all 5 last digits = 0.

You analyse the 142,506 possible number combinations, ranked in ascending order. Your analysis looks correct. But whereas for the last digit combination 5|6|7|8|9, say, I have one line showing 243 combinations, you have:

5678921
567986
568796
568976
569786
569871
576896
576981
578696
578966
579686
579861
586796
586971
587691
587961
589676
589761
596786
596871
597681
597861
598671
657896
657981
658791
658971
659781
675896
675981
678596
678956
679586
679851
685796
685971
687591
687951
689576
689751
695786
695871
697581
697851
698571
756896
756981
758691
758961
759681
765891
768591
768951
769581
785696
785961
786591
786951
789566
789651
795686
795861
796581
796851
798561
856796
856971
857691
857961
859671
865791
867591
867951
869571
875691
879561
895676
895761
896571
896751
897561
956786
956871
957681
957861
958671
965781
967581
967851
968571
975681
978561
985671
243


Our results are the same, just analysed differently.
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top