Can someone give me a formula?Previous TopicNext Topic

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.

ABCDE

=

ABCD

ABCE

ACDE

BCDE

You need to go back to your original post, here. http://www.lotterypost.com/thread/196264

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

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

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.

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.

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.

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)