5-digit combination

Question

Hello,
I would like to obtain all combinations of 5 digits (without duplicates), in the form of an Excel table
for example
I have 20 numbers (1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20)
I would like to get ALL THE COMBINATIONS of 5 digits in any order (with 14, then 15, then 16, then 17, then 18, then 19, and finally 20 digits)
1 5 3 8 9
18 20 11 6 7
3 6 8 4 1
6 7 5 12 18
etc etc etc

if someone can help me IN THE FORM OF AN EXCEL TABLE
I don't know much about formulas
Thank you
Achile

Configuration: Windows XP / Internet Explorer 8.0

Configuration: Windows XP / Internet Explorer 8.0

JeDetesteMaPSP · Accepted Answer

I don't understand, at worst make a spreadsheet to put the values in, but I'm not sure it will work.
What is this table for?

At worst we can program it in PHP/C++/JS (I only know how to do it in PHP and even then it's mediocre but after it's pretty much the same...).
You need to put a value in a cell and generate a number in a loop

if $completed_table = // number of possible combinations

while $completed_table = // number of possible combinations
echo $A = 1
$A++

And the same until E?
No? Something like that? I'm not managing sorry =(.
I'm just starting =(.
By the way, the " // " means comments :P.
To calculate the number of possibilities you have to do this.

Number of columns (for example 5)
And the maximum number of possibilities t( 20 right? )
And then you subtract 1 each time
20 x 19 x 18 x 17 x 16
( there are 5 int/float values (numbers :P ) that I subtracted one when I moved from value, did you understand? :D ).
--
Sorry for my not very pleasant writing let's say :D.

athena223 · Answer

Good evening,  with 3,200,000 possibilities, it's going to make a very, very long table... -- doing research yourself before posting on CCM is the quickest solution!

JeDetesteMaPSP · Answer

Yes ='). 20 x 19 x 18 x 17 x 16  Precisely: 1,860,480  How did you get this result Athena? Normally it's my method =/.

athena223 · Answer

he didn't say that the same number couldn't appear multiple times in the same combination ...

oh sorry, was that the (no duplicates)?
--
doing your own research before posting on CCM is the fastest solution!

JeDetesteMaPSP · Answer

What's your formula?  -- Sorry for my not very pleasant writing, let's say :D.

athena223 · Answer

I think he's talking about duplicates in the table  otherwise 1 1 1 1 1 etc counts, so 20 x 20 x 20 x 20 x 20 -- doing your own research before posting on CCM is the quickest solution!

JeDetesteMaPSP · Answer

Oh yes :D.  -- Sorry for my not very nice writing, let's say :D.

achile.2.3 · Answer

Good evening,thank you for your answers, I didn't realize it represented so many figures and possibilities. Can we do it with 8 or even 10 digits (or more, or less...) to reduce the capacity, the volume... and if so, could you show me that in an Excel spreadsheet? I don't know the formulas in algorithms...thank you

athena223 · Answer

A factor of 10 seems reasonable; that makes 100,000 combinations of 5 digits.   I’m not very skilled in Excel, but in what format do you want it? One single column for all possibilities?  Or something else? Because the advantage of 10 is that the formula is simplified; you just need to add +1 each time.  You will just need to add the combinations with the number 10.   It could then take a form like this   1 / 1 / 1 / 1 / 1  1 / 1 / 1 / 1 / 2  ...  ... (1 / 1 / 1 / 1 / 10) this isn't great in math, lol  1 / 1 / 1 / 2 / 1   But still, it takes quite a bit of work and a huge table.  But what is it for? Because separating it into several tables of 10,000 combinations wouldn't be bad either...  --  Doing research yourself before posting on CCM is the fastest solution!

achile.2.3 · Answer

Good evening Athena,

thank you for your message, I would like to have them in a spreadsheet (like Excel) on several columns (A B C D E), even if it means creating multiple Excel sheets, but above all how this formula works, to obtain 5 numbers from selections of 8/9/10 or more, in any order, not necessarily ascending, and without duplicates...
EXAMPLE
8 6 9 2 4
5 6 2 7 10
3 6 4 2 8
1 5 6 2 8
6 9 8 4 5
ETC ETC

THANK YOU for your help

Raymond PENTIER · Answer

Hello Achile.  I'm sorry, but to my knowledge, there is no formula to determine those combinations. At most, there is a formula to calculate how many solutions exist! And anyway, what could you actually do with a list of several million results? Absolutely nothing! Think about that...  Best regards. -- Retirement is great! Especially in the Caribbean... :-) &#9787; Raymond &#9794;

JeDetesteMaPSP · Answer

According to you, how did they calculate that there was a one in 13 million chance of winning the lottery?
Formula!!

My formula is correct, I saw it on E=M6 :P.

Your neurons have overheated under the sun of Guadeloupe/Martinique =P.
--
Sorry for my not very pleasant writing, let's say :D.

achile.2.3 · Answer

Good evening everyone,

thank you for your messages.
If there are no possibilities, then I will try to find a way to do it based on 5 digits (1 2 3 4 5)
for example
1 2 3 4 5
1 2 3 5 4
1 2 5 4 3
etc etc
logically I should obtain 120 solutions - Then I will try to change the digits by including 6, then 7, then 8 digits up to 10
I don't think I will end up with, as you say, 13 million possibilities...
If someone can help me, I'm stuck on the formulas in Excel...
thank you all
Achile

Raymond PENTIER · Answer

I repeat: THERE IS NO FORMULA FOR THAT!

The formula =PERMUTATION(5;5) indeed gives 120 (which I abandoned listing).
When moving to 5 digits out of 6, we get 720 permutations.
Then 30240 for 10 digits, 360360 for 15 digits, and 1860480 for 20 digits.

The formula =COMBIN(5;5) gives 1 combination ► 12345
=COMBIN(6;5) gives 6 combinations ► 12345 12346 12356 12456 13456 23456
=COMBIN(10;5) gives 252 combinations
=COMBIN(15;5) gives 3003 combinations
=COMBIN(20;5) gives 15504 combinations.

Indeed, I’m not quite sure what you want anymore, since in your first post (and in the title of your discussion) you talked about combinations, and now in post 14 you’re giving examples of permutations...

https://www.cjoint.com/?dcclI8lNnc
--
Retirement is nice! Especially in the Antilles... :-)
☻ Raymond ♂

achile.2.3 · Answer

GOOD EVENING RAYMOND,  yes, indeed, I am looking to get all the combinations (but not necessarily in ascending order, in all directions, let me explain: I have an example 1 2 3 4 5 I would like to know the technique to obtain all the numbers of 1 2 3 4 5 in all directions for example 2 3 4 5 1 1 5 2 4 3 3 5 2 4 1 etc etc etc  and do the same for adding the 6th, 7th, 8th numbers etc...  YOU GAVE ME formulas, but sorry, I don't know much about formulas, how do you transcribe them into an Excel table...  you mention: The formula =PERMUTATION(5;5) indeed gives 120 (which I have stopped listing). Going to 5 digits among 6 gives us 720 permutations. Then 30240 for 10 digits, 360360 for 15 digits, and 1860480 for 20 digits.  The formula =COMBIN(5;5) gives 1 combination &#9658; 12345 =COMBIN(6;5) gives 6 combinations &#9658; 12345 12346 12356 12456 13456 23456 =COMBIN(10;5) gives 252 combinations =COMBIN(15;5) gives 3003 combinations =COMBIN(20;5) gives 15504 combinations.  how do you put that into a table? ? thank you for your response achile

Raymond PENTIER · Answer

I had attached the table to you. You at least need to open the link ...

And I repeat once again: these formulas calculate how many solutions there are, but do not provide the list of all these solutions!!!
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

Vaucluse · Answer

Hello everyone come on, don’t get angry my friend Raymond, (you’re going to get heated again) there’s no need to edit all the combinations, it’s enough to find the winning combination. Just one is enough Good Antilles  -- Let’s ask ourselves if we are not alone in understanding what is being explained?

JeDetesteMaPSP · Answer

Hello, Yes, I didn't understand, Raymond, there is no formula to get the lists of combinations but to count them yes :D. I think we can code it to get the lists, right? But it won't be on Excel, it will be on a site (that you can then copy/paste afterwards). It should be in PHP, it would look like this. I think it’s wrong, but it would look like this... PS: E=M6 is a TV show that airs on M6 precisely (hence the name). For 10 on this example ' } while $case2 = 10 { $case2++ echo $case2 . '
' } ?> And you do that for each $case and change the 1/2 to other values. It's possible that it works but I'm not sure =/ -- Sorry for my writing, it's not very pleasant, let's say :D.

JeDetesteMaPSP · Answer

Matrix with password to hack :O -- Sorry for my not very pleasant writing, let's say :D.

achile.2.3 · Answer

Good evening everyone,  I didn't understand much about formulas and programming, could someone provide them to me via an Excel spreadsheet so I can understand?  Thanks to all Achile

pijaku · Answer

Hello, We suspect that you haven’t understood everything. However, several times we have asked you what exactly you want and especially what result you want to achieve. Reread this entire topic, answer these questions, and we'll help you without any problem... -- Best regards, -- Every problem has a solution. If there is no solution, where is the problem? --

JeDetesteMaPSP · Answer

-Why are you doing it?
-Are you ready to spend 1.9 GB on a text file? It's your choice.
-Do you know how to do PHP?
-Do you really want it in table format? Or is a text file okay?

--
Sorry for my mistakes. Not just spelling, of course =).

JeDetesteMaPSP · Answer

For the php,

I'm telling him that because I could make this table, but he will have to be ready to spend almost 2GB for a text file.
I can manage to get all the values, but not in Excel, only in a text file, a site generated in PHP.
If he wants =/.

I can do it, but not in Excel!!

1,860,000 combinations.
--
Sorry for my mistakes. Not just spelling mistakes, of course =).

JeDetesteMaPSP · Answer

Well,  Let's imagine,  10 groups of 5 people = 50 200 people for a total of 40 groups of 5 people.  I need to think about it... -- Sorry for my mistakes. Not just spelling ones, of course =).

Vaucluse · Answer

Hello
I'm going to take back your explanation that I find a bit confusing:

"To find my way, I named the staff in teams of 5 (which still corresponds to more than 40 teams). And my goal is to rotate these teams on these machines without ever putting them 2 times on different machines, and especially without forgetting any, it's a real Chinese puzzle for us..."

without ever putting them 2 times on different machines
1°) If it's to not put them twice on two different machines, what is the purpose of your question?

To find my way, I named the staff in teams of 5
2°) If you have named your staff in teams, is it the personnel within the team that you want to rotate or is it the teams?

Because if it's about the teams, we don't see how this corresponds to your question? And the problem is about 40 combinations (if you need to change the posts, of course) because then you'll only cover the number of posts before having to put a team back on a post they already know.
All you have to do is make a list from 1 to 40 and shift by one machine every day!
So, there may be a solution, but to adjust the question to your needs, be more precise about:
the change of posts
the composition of the teams
the number of solutions you envision, related to a reasonable period to cover because 20,000,000 (or something close; let's round it) of combinations represent an option that even by pushing back the retirement age far enough, no one will have time to implement (around 20,000,000 / 5/48= 83,000 days which corresponds to about 330 years in terms of working years)
Even reduced to 200,000 remains 33 years!

Best regards

--
Let's ask ourselves if we are not alone in understanding what is being explained?

proviste · Answer

it's equal to
20x19x18x17x16 all divided by 5x4x3x2x1
that is

15504 combinations

if you want to play only even or odd numbers in the lottery, you will still need 30,000 euros in stakes without being sure of winning
good luck

5-digit combination

26 réponses

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french