is there a way to enter a few numbers in combin function and make it so excel displays all the possible combinations? i need this to be sure i will not get 2 same combinations if i make them by hand. was i clear? is there a way?
Hi , I have asked this question about a hundred times but i have to keep trying to find somebody to help so here goes again. I never even get a reply. Is it really that difficult because i have tried and failed a thousand times. Question How can i use combin, (not combina) to create a list of all the combinations of 24 from 35. I need to create a list from low to high in a column. Thanks Jim
Great job, let me see what would it be the next close winning number I can do Permutation with the lotto number to get the probability of the Jack pot number, wish me luck!, thanks. Respectfully; Andy
I want to make a combination of 4 letters ( whether meaningful or not) out of 26 Alphabets , is there is any formula which can show all the maximum results. For example : i want 4 letter nzgy out of A-Z alphabets. Kindly help
+pankaj kumar this is a combination. Since you want any four different letters out of 26, you just have 26C4. That gives how many ways there are to take 4 different letters out of 26 different letters.
I'm not sure how to solve this with excel: How many different ways can a chairperson and an assistant chairperson be selected for a research project if there are seven scientists available?The first person selected will be the chairperson
+Ash Shah sounds like the order of choosing matters. You get two choices, but the first choice is a chairperson and the second is is assistant. So 7 choices for first choice and 6 for second choice. 7*6 = 42 ways
Great job! Straight to the point!! Wonderful!
Right to the point. I love it.
Thank you - your videos are so easy to follow!
is there a way to enter a few numbers in combin function and make it so excel displays all the possible combinations? i need this to be sure i will not get 2 same combinations if i make them by hand. was i clear? is there a way?
yes Cody.. I want that combination with actual results containing 4 characters
Hi , I have asked this question about a hundred times but i have to keep trying to find somebody to help so here goes again. I never even get a reply. Is it really that difficult because i have tried and failed a thousand times.
Question
How can i use combin, (not combina) to create a list of all the combinations of 24 from 35.
I need to create a list from low to high in a column.
Thanks Jim
Actually I want to give only one sunday leave to different labours. so how to set this formula in excel ?
Great job, let me see what would it be the next close winning number I can do Permutation with the lotto number to get the probability of the Jack pot number, wish me luck!, thanks.
Respectfully;
Andy
I want to make a combination of 4 letters ( whether meaningful or not) out of 26 Alphabets , is there is any formula which can show all the maximum results.
For example : i want 4 letter nzgy out of A-Z alphabets.
Kindly help
+pankaj kumar this is a combination. Since you want any four different letters out of 26, you just have 26C4. That gives how many ways there are to take 4 different letters out of 26 different letters.
Thx cody , i used the formula , the outcome is 325 but i want all the 325 combination how can i find it
+pankaj kumar you mean where you can repeat letters? for example: zzzz ? 26*26*26*26 since there are 26 options for each choice
I'm not sure how to solve this with excel: How many different ways can a chairperson and an assistant chairperson be selected for a research project if there are seven scientists available?The first person selected will be the chairperson
+Ash Shah sounds like the order of choosing matters. You get two choices, but the first choice is a chairperson and the second is is assistant. So 7 choices for first choice and 6 for second choice. 7*6 = 42 ways
Cody Tabbert Thank you!