Welcome Guest
Log In | Register )
You last visited December 9, 2016, 12:16 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 4 Excel Formula

Topic closed. 2 replies. Last post 9 years ago by winsumloosesum.

Page 1 of 1
PrintE-mailLink
paulfig911's avatar - stack of_money.jpg
New Member
Toronto
Canada
Member #43108
July 13, 2006
6 Posts
Offline
Posted: July 13, 2007, 12:30 pm - IP Logged

Could someone tell me the formula I can use in Excel to calculate all 10,000 possible combinations for Pick 4 lottery?

Thank you.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: July 13, 2007, 2:14 pm - IP Logged

    Paul,

    Not sure what you want.

    If you just want a list of 10,000 Pick 4 combinations just enter 0000 in cell A1

    Click cell A1

    Right Click>Format Cells>Select Number Tab (top)>Secect Custom (List)>Select 0 in the Type: (right side)

    Enter 3 more zero's for a total of 4

    Click OK

    Cell A1 should have four zero's

    Select cell A1 and place coursor at right hand lower corner.

    Hold down the left mouse button and Drag the cross hairs down to cell A2.

    Click cell A2 and delete the 0000.

    Enter this formula =A1+1 in cell A2 (This will add 1 to 0000

    You should now see 0001 in cell A2

    Click Cell A2 and place the cursor over the right lower corner until you see a cross hair

    Hold down the left mouse button and drag all the way down to cell A10000

    You should now have Pick 4 combinations from 0000 through 9999

    The last thing you should do is highlight the entire column "A"

    Right click>Select copy

    Right Click>Paste Special

    Select "Values" under the Paste: column and Select OK

    Now you can add more to this worksheet by entering formulas for positions 1 through 4 in cell columns B1 through E1 

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: July 13, 2007, 2:20 pm - IP Logged

      Adding Position formulas for Pick 4:

      Thanks to Hypersoniq for these formulas!!! 

      Assuming  Column Cell A1 is where you enter the 4 digit combos ...

      Position 1 in cell B1 ...  =INT(A1/1000)

      Position 2 in cell C1 ...  =INT((A1-(B1*1000))/100)

      Position 3 in cell D1 ...  =INT((A1-((B1*1000)+(C1*100)))/10)

      Position 4 in cell E1 ...  =INT((A1-((B1*1000)+(C1*100)+(D1*10))))

      After you enter all these formulas just drag down until you have all 10000 combinations.