Welcome Guest
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
New Member
Toronto
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.

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

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.

 Page 1 of 1