ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 963
- Office Version
- 365
- 2010
- Platform
- Windows
I want to create a gird as follows:
Cell A1 = Number
Cells A2 through A40 = numbers 1 through 39
Cell B1 = P1 (Position 1)
Cell C1 = P1 (Position 2)
Cell D1 = P1 (Position 3)
Cell E1 = P1 (Position 4)
Cell F1 = P1 (Position 5)
Cell B2 = formula for counting how many times the number 1 appears in the 1st position of a 5/39 lottery game
Cell B3 = formula for counting how many times the number 2 appears in the 1st position of a 5/39 lottery game
Etc., etc.
Cell C3 = formula for counting how many times the number 2 appears in the 2nd position of a 5/39 lottery game
Thank you in advance!!
Cell A1 = Number
Cells A2 through A40 = numbers 1 through 39
Cell B1 = P1 (Position 1)
Cell C1 = P1 (Position 2)
Cell D1 = P1 (Position 3)
Cell E1 = P1 (Position 4)
Cell F1 = P1 (Position 5)
Cell B2 = formula for counting how many times the number 1 appears in the 1st position of a 5/39 lottery game
Cell B3 = formula for counting how many times the number 2 appears in the 1st position of a 5/39 lottery game
Etc., etc.
Cell C3 = formula for counting how many times the number 2 appears in the 2nd position of a 5/39 lottery game
Thank you in advance!!