Welcome Guest
You last visited December 11, 2016, 4:50 am
All times shown are
Eastern Time (GMT-5:00)

# Can someone give me a formula?

Topic closed. 7 replies. Last post 7 years ago by LottoMining.

 Page 1 of 1
New Member
North Easton, Ma
United States
Member #76392
June 26, 2009
3 Posts
Offline
 Posted: June 30, 2009, 9:13 am - IP Logged

Hi,

How can I figure out how many 4 digit combinations can be made from 5 digits.

Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

Any help is appreciated.

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: June 30, 2009, 9:50 am - IP Logged

ABCDE

=

ABCD

ABCE

ACDE

BCDE

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5913 Posts
Offline
 Posted: June 30, 2009, 9:51 am - IP Logged

Hi,

How can I figure out how many 4 digit combinations can be made from 5 digits.

Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

Any help is appreciated.

Then download the software. Then you will be able to do this. Just an example using any 5 digits.

0123, 0124, 0132, 0134, 0142, 0143, 0213, 0214, 0231, 0234, 0241, 0243, 0312, 0314, 0321, 0324, 0341, 0342, 0412, 0413, 0421, 0423, 0431, 0432, 1023, 1024, 1032, 1034, 1042, 1043, 1203, 1204, 1230, 1234, 1240, 1243, 1302, 1304, 1320, 1324, 1340, 1342, 1402, 1403, 1420, 1423, 1430, 1432, 2013, 2014, 2031, 2034, 2041, 2043, 2103, 2104, 2130, 2134, 2140, 2143, 2301, 2304, 2310, 2314, 2340, 2341, 2401, 2403, 2410, 2413, 2430, 2431, 3012, 3014, 3021, 3024, 3041, 3042, 3102, 3104, 3120, 3124, 3140, 3142, 3201, 3204, 3210, 3214, 3240, 3241, 3401, 3402, 3410, 3412, 3420, 3421, 4012, 4013, 4021, 4023, 4031, 4032, 4102, 4103, 4120, 4123, 4130, 4132, 4201, 4203, 4210, 4213, 4230, 4231, 4301, 4302, 4310, 4312, 4320, 4321
0012, 0013, 0014, 0021, 0023, 0024, 0031, 0032, 0034, 0041, 0042, 0043, 0102, 0103, 0104, 0112, 0113, 0114, 0120, 0121, 0122, 0130, 0131, 0133, 0140, 0141, 0144, 0201, 0203, 0204, 0210, 0211, 0212, 0221, 0223, 0224, 0230, 0232, 0233, 0240, 0242, 0244, 0301, 0302, 0304, 0310, 0311, 0313, 0320, 0322, 0323, 0331, 0332, 0334, 0340, 0343, 0344, 0401, 0402, 0403, 0410, 0411, 0414, 0420, 0422, 0424, 0430, 0433, 0434, 0441, 0442, 0443, 1002, 1003, 1004, 1012, 1013, 1014, 1020, 1021, 1022, 1030, 1031, 1033, 1040, 1041, 1044, 1102, 1103, 1104, 1120, 1123, 1124, 1130, 1132, 1134, 1140, 1142, 1143, 1200, 1201, 1202, 1210, 1213, 1214, 1220, 1223, 1224, 1231, 1232, 1233, 1241, 1242, 1244, 1300, 1301, 1303, 1310, 1312, 1314, 1321, 1322, 1323, 1330, 1332, 1334, 1341, 1343, 1344, 1400, 1401, 1404, 1410, 1412, 1413, 1421, 1422, 1424, 1431, 1433, 1434, 1440, 1442, 1443, 2001, 2003, 2004, 2010, 2011, 2012, 2021, 2023, 2024, 2030, 2032, 2033, 2040, 2042, 2044, 2100, 2101, 2102, 2110, 2113, 2114, 2120, 2123, 2124, 2131, 2132, 2133, 2141, 2142, 2144, 2201, 2203, 2204, 2210, 2213, 2214, 2230, 2231, 2234, 2240, 2241, 2243, 2300, 2302, 2303, 2311, 2312, 2313, 2320, 2321, 2324, 2330, 2331, 2334, 2342, 2343, 2344, 2400, 2402, 2404, 2411, 2412, 2414, 2420, 2421, 2423, 2432, 2433, 2434, 2440, 2441, 2443, 3001, 3002, 3004, 3010, 3011, 3013, 3020, 3022, 3023, 3031, 3032, 3034, 3040, 3043, 3044, 3100, 3101, 3103, 3110, 3112, 3114, 3121, 3122, 3123, 3130, 3132, 3134, 3141, 3143, 3144, 3200, 3202, 3203, 3211, 3212, 3213, 3220, 3221, 3224, 3230, 3231, 3234, 3242, 3243, 3244, 3301, 3302, 3304, 3310, 3312, 3314, 3320, 3321, 3324, 3340, 3341, 3342, 3400, 3403, 3404, 3411, 3413, 3414, 3422, 3423, 3424, 3430, 3431, 3432, 3440, 3441, 3442, 4001, 4002, 4003, 4010, 4011, 4014, 4020, 4022, 4024, 4030, 4033, 4034, 4041, 4042, 4043, 4100, 4101, 4104, 4110, 4112, 4113, 4121, 4122, 4124, 4131, 4133, 4134, 4140, 4142, 4143, 4200, 4202, 4204, 4211, 4212, 4214, 4220, 4221, 4223, 4232, 4233, 4234, 4240, 4241, 4243, 4300, 4303, 4304, 4311, 4313, 4314, 4322, 4323, 4324, 4330, 4331, 4332, 4340, 4341, 4342, 4401, 4402, 4403, 4410, 4412, 4413, 4420, 4421, 4423, 4430, 4431, 4432
0001, 0002, 0003, 0004, 0010, 0020, 0030, 0040, 0100, 0111, 0200, 0222, 0300, 0333, 0400, 0444, 1000, 1011, 1101, 1110, 1112, 1113, 1114, 1121, 1131, 1141, 1211, 1222, 1311, 1333, 1411, 1444, 2000, 2022, 2111, 2122, 2202, 2212, 2220, 2221, 2223, 2224, 2232, 2242, 2322, 2333, 2422, 2444, 3000, 3033, 3111, 3133, 3222, 3233, 3303, 3313, 3323, 3330, 3331, 3332, 3334, 3343, 3433, 3444, 4000, 4044, 4111, 4144, 4222, 4244, 4333, 4344, 4404, 4414, 4424, 4434, 4440, 4441, 4442, 4443
0011, 0022, 0033, 0044, 0101, 0110, 0202, 0220, 0303, 0330, 0404, 0440, 1001, 1010, 1100, 1122, 1133, 1144, 1212, 1221, 1313, 1331, 1414, 1441, 2002, 2020, 2112, 2121, 2200, 2211, 2233, 2244, 2323, 2332, 2424, 2442, 3003, 3030, 3113, 3131, 3223, 3232, 3300, 3311, 3322, 3344, 3434, 3443, 4004, 4040, 4114, 4141, 4224, 4242, 4334, 4343, 4400, 4411, 4422, 4433
0000, 1111, 2222, 3333, 4444

CA
United States
Member #2987
December 10, 2003
832 Posts
Offline
 Posted: June 30, 2009, 11:35 am - IP Logged

I just did an Excel chart similar to this but for Pick 3. Pick 4 would be 10 times as large, of course. I presently have no plans to work on something like this, as 10,000 cells would have to be individually formatted. But:

There are 625 4-digit combinations that can be formed using 4 digits from the first 5-digit group. This includes doubles, triples and quads.
There are 2,500 4-digit combinations that can be formed using 3 digits from the first 5-digit group and 1 digit from the second 5-digit group. This includes doubles and triples.
There are 3,750 4-digit combinations that can be formed using 2 digits from the first 5-digit group and 2 digits from the second 5-digit group. This includes doubles and combinations where there are two sets of doubles.
There are 2,500 4-digit combinations that can be formed using 1 digit from the first 5-digit group and 3 digits from the second 5-digit group. This includes doubles and triples.
There are 625 4-digit combinations that can be formed using 4 digits from the second 5-digit group. This includes doubles, triples and quads.

The Excel output would have to be text to allow the first digit in an individual cell to be a zero. The finished chart would have 400 rows and 25 columns, 200 rows and 50 columns, or 100 rows and 100 columns, depending on preference.

There are several ways to display the results; my personal preference is to use a formula that can be copied, then easily edited to cover all the possibilities.

Assuming the initial 5-digit group is posted in Cell A1, the first cell in which output is desired would have the formula =MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1). This formula yields a quad consisting of the first number in the first 5-digit group. Note that MID is used for all output, not LEFT or RIGHT - this allows for easier editing of the copied formula to other cells. If I were continuing, the cell immediately to the right of the first output cell would have the formula =MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1)&MID(A1,2,1). This would yield a triple, consisting of the first number in the first 5-digit group three times and the second number in the first 5-digit group once.

Hope you get the idea.

gl

j

Blessed Saint Leibowitz, keep 'em dreamin' down there.....

Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

=^.^=

Kentucky
United States
Member #32652
February 14, 2006
7325 Posts
Offline
 Posted: July 1, 2009, 9:43 am - IP Logged

Hi,

How can I figure out how many 4 digit combinations can be made from 5 digits.

Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

Any help is appreciated.

I believe it's called factoring when any of 5 digits can appear in any of the four positions. To get the total number of combinations you multiple 5 (first position) times 5 (second) times 5 (third) times 5 ( fourth) equals 625. If you're using the digits 1-2-3-4-5 it would look like (1-2-3-4-5) with (1-2-3-4-5) with (1-2-3-4-5) with (1-2-3-4-5).

You'll probably need a program that generates all 625 combinations and allows you to apply filters.

NY
United States
Member #23835
October 16, 2005
3475 Posts
Offline
 Posted: July 21, 2009, 3:42 pm - IP Logged

Perhaps you're thinking of factorials (n!), which are a number multiplied by each whole number that is less than that number and greater than zero. For 5 it's 5*4*3*2*1, which is 120. There are 120 permutations for 5 numbers if you use all 5 of them. In a permutation the order of the numbers matters.  For combinations, OTOH, the order doesn't matter. 1,2,3,4,5 and 5,4,3,2,1 are different permutations, but represent irrelevant variations of the same combination. The formulas for permutations and combinations start with the factorial of the full set of numbers, which is then reduced based on how many of the numbers are being used, and whether you want the number of permutations or combinations.

For 4 of 5 it's 5! / (4! * (5-4)! ), which simplifies to 5! /  ( 4! * 1 )  -->  5! / 4!  = 5.

The list above omitted  the 5th combination of ABDE.

mid-Ohio
United States
Member #9
March 24, 2001
19831 Posts
Offline
 Posted: July 21, 2009, 7:49 pm - IP Logged

Hi,

How can I figure out how many 4 digit combinations can be made from 5 digits.

Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

Any help is appreciated.

You can down load a free program from LottoLogix called "Maybelle QuickWheel" that will calculate that it's 625 combinations and print them out for you.

* you don't need to buy more tickets, just buy a winning ticket *

California
United States
Member #48843
January 11, 2007
27 Posts
Offline
 Posted: July 23, 2009, 12:32 am - IP Logged

If you had a database program such as MS Access, you could create a table named tblRnd1 with a single field named Num of data type number (though data type of text works too). Then populate your table with the five digits.

This query right below outputs the 625 records / combos (assuming you named the table as listed above and populated it):

SELECT tblRnd1.Num, tblRnd1_1.Num, tblRnd1_2.Num, tblRnd1_3.Num

FROM tblRnd1,

tblRnd1 AS tblRnd1_1,

tblRnd1 AS tblRnd1_2,

tblRnd1 AS tblRnd1_3;

(note: copy/paste the above in a new query in "SQL View", which is found on the pull down menu)

You could save the above as a stored query and then query it with all your filters.

 Page 1 of 1