Best Answer

There is no built in function in Excel to create a list of combinations of 39 items taken 5 at a time. However, the combin function will tell you how many combinations there are. For instance, combin(39,5) = 575757.

Q: What formula can you input into excel to come up with all the 5 number different combinations for numbers 1-39?

Write your answer...

Submit

Still have questions?

Continue Learning about Math & Arithmetic

If the numbers can be repeated and the numbers are 0-9 then there are 1000 different combinations.

Just use combinations formula. nCr, where n=44, r=6. Plug it into the calculator or use the formula, nCr = n!/[r!(n-r)!] And you should get 7059052 as the number of combinations.

The number of combinations of six numbers that can be made from seven numbers will depend on if you can repeat numbers. In all there are over 2,000 different numbers that can be made.

120 WRONG! That is the number of PERMUTATIONS. In the case of combinations, the order of the numbers does not matter, so there is only 1 5-number combination from 5 numbers.

Using the formula n!/r!(n-r)! where n is the number of possible numbers and r is the number of numbers chosen, there are 13983816 combinations of six numbers between 1 and 49 inclusive.

Related questions

If the numbers can be repeated and the numbers are 0-9 then there are 1000 different combinations.

Just use combinations formula. nCr, where n=44, r=6. Plug it into the calculator or use the formula, nCr = n!/[r!(n-r)!] And you should get 7059052 as the number of combinations.

Number of combinations = 45C6 = 45!/6!(45-6)! = 8,145,060

The number of combinations of six numbers that can be made from seven numbers will depend on if you can repeat numbers. In all there are over 2,000 different numbers that can be made.

120 WRONG! That is the number of PERMUTATIONS. In the case of combinations, the order of the numbers does not matter, so there is only 1 5-number combination from 5 numbers.

Number of 7 digit combinations out of the 10 one-digit numbers = 120.

Assuming that the six numbers are different, the answer is 15.

If you can repeat the numbers within the combination there are 10,000 different combinations. If you cannot repeat the numbers within the combination, there are 5040 different combinations.

all numbers have to be different 720 360 (6*5*4*3*2*1), * * * * * Wrong. Combinations do not have to be different. Those are permutations. There are only 6C4 = 6*5/(2*1) = 15 combinations.

Using the formula n!/r!(n-r)! where n is the number of possible numbers and r is the number of numbers chosen, there are 13983816 combinations of six numbers between 1 and 49 inclusive.

8C6 = 28

You can make 5 combinations of 1 number, 10 combinations of 2 numbers, 10 combinations of 3 numbers, 5 combinations of 4 numbers, and 1 combinations of 5 number. 31 in all.