1. V

    Combination And Permutation with no repeat

    Thanks in advance in column "A", i have the numbers, suppose it is 0 to 99 (1) Now i want the list of generated numbers through combination with no repeats in the set of 5, please provide any vba code (2) I want the list of generated numbers through permutation with no repeats in the set of...
  2. R

    Get all possible permutations

    Hello Team, I want to make all possible permutations of a name. I have a name like X Y Z and i have separate this name on the basis of space so now I have A1 - X B1 - Y C1 - Z In D1 I want to get all possible permutation of X Y Z for example X Y Z or Y X Z or Z X Y and so on.. or should be...
  3. M

    VBA how much permutation can be made using 3-digit with 0, 1 & 2

    Hello,</SPAN></SPAN> I want to know is there any formula, which can count permutation can be made using 3-digit with 0, 1 & 2 </SPAN></SPAN> And a VBA, which can make all possible permutation, using 3-digit with 0, 1 & 2 using 7 cells with in the row which row sum must be =...
  4. A

    Combination of numbers in a range

    Please help me to find a solution...I have populated column C and Column D with single numbers and Column E the numbers are concatenated. How do I generate a list of all possible COMBINATIONS of the Column E with all the other single numbers located in Columns C and D except numbers located in...
  5. K

    Require change to limit exact sum output combinations

    Using Excel2000 Hi, Till now I was using "pgc01 code" which is amazing, I found code under this link I require modifications code only output Permutation Repetition with a desire sums For...
  6. C

    Permutations and List Making with a variable - please help!!

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}span.s1 {text-decoration: underline}</style>Hello Mr.Excel Forum - What an amazing forum! I...
  7. S

    Permutation problem

    Hi - I would like to generate all the 5 digit long permutations that can be constructed from a pool of 30 unique digits. The pool of 30 digits are: 2, 3, 4, 6, 7, 8, 9, A, B, C, D, E, F, G, H, J, K, L, M, N, P, Q, R, T, U, V, W, X, Y, Z. [O, 0, 5, S, I, 1] are excluded due to the likelihood of...
  8. N

    Combination with repetitions into excel for multiple data

    Hi guys! New tothe forum and first post for me, I tried to figure it out on my own and by looking on this forum, but not sure my mind is completely clear. I have to say I'm quite new to this kind of statistics, so apologize if the question is actually easy! I want to calculate the total...
  9. M

    How to generate all possible combinations with 2 sets??? please its urgent

    Say there is a column with number 1,2,3,4 and 5 and there is another column with alphabets A,B,C,D now what I want is that each number combine with a alphabet such that for same combination no other number occupy the previous alphabet. For example. Combination 1: 1A - 2B - 3C - 4D (if a...
  10. K

    VBA Permutate Different Strings

    Netizens, Let's say I have a row filled with three different strings: <tbody> Dog Cat Mouse </tbody> How do I create a permutation algorithm that will generate the following outputs? Thanks in advance! <tbody> Dog Cat Mouse Dog Mouse Cat Cat Dog Mouse Cat Mouse Dog Mouse Cat Dog...
  11. C

    Permutations of Set of Numbers in a Column

    I have searched all over the internet but am having trouble finding the answer to my problem. I would like to write a macro that will list the possible permutations of a column, in the column right next to it. For instance, see columns 1 and 2: <tbody> 1 1 Permutation1 2 2 Permutation1 3 3...
  12. R

    Permutations or Combinations from sets of numbers

    I have searched all the forms to try and find a solution for this. I have found lots of permutation algorithms - have even written a few but I cannot figure out how to do this. I have x set of groups that have x numbers in each group. For example group1(1,2,3,4) group2(2,4) group3(1,2,4) I...
  13. E


    Hi guys, I wonder if someone could help me with this query. I wish to get all the possible unique combinations out of this table. From Single column to Wireless/None column. So there should always be 7 combination for every turn. The order of these categories is very important so I can't have a...
  14. V

    Replicating data from a list

    Hi, I have 2 lists: [Note: Treat the commas as separate columns] LIST A: loc1 lo-2 loo3 loi4 LIST B: 1,abba,75 2,babba,356 3,bom,22 Final Product Required: 1,abba,75,loc1 2,babba,356,loc1 3,bom,22,loc1 1,abba,75,lo-2 2,babba,356,lo-2 3,bom,22,lo-2 . .. ... .. 3,bom,22,loi4 So basically...
  15. T

    Combinations (Groups of 10 from 13 digits)

    I am using Excel 2003 (xls file). My problem is similar to many permutation/combination problems but I looked at the other threads and could not find a way to apply the solution to my problem (I am not very Excel-competant, sadly). I have 13 objects that I am using labels (A,B,C, etc) for. I...
  16. M

    Listing permutations of multiple cells(text&numbers) in sequence.

    I'll try to explain myself, please bear with me. I have four list, shown below, that i need all the permutations/combinations in sequence: YearMonth,Number,Location. Example: 20071,102,Vietnam......"blank"12,104,Canada....and so on. Hope thats clear enough. Thanks in advance. <TABLE...
  17. S

    Stringing together combinations of two

    I'm fairly inexperienced with excel, so I may need a lot of help. This also may not be possible with excel. Here I go: I have a 2-column list of words that I know must go together in order. The columns looks like this: bar graph bell pepper bell service board room car door car pool trail...
  18. A

    Generating permutations on three factors

    Afternoon all. I attempting to generate a list of possible permutations based on 3 possible factors (one factor of 227 possibilities, a second factor or 8 possibilities and a final factor of 25 possibilities). The combinations are starting to blow my mind a little. As a brief example I'm...
  19. 2

    Generate permutation of 12 Characters in Excel

    I have no clue about permutation jargon so in the simplest possible lay man terms can someone talk me through how to generate all the possible permutations/sequence for the following twelve characters. 2Q3QS7ULVJY1 Many Thanks 2ray.
  20. D

    Permutations/ combinations problem

    Hi there, I have a problem in which I have to list all the possible combinations of a series of numbers starting with 1 and going to 12, or 15, for example. I need to list all the possible combinations using any 2, 3, 4 or 5 of those numbers. Furthermore, a number can only be used once in a...

Some videos you may like

This Week's Hot Topics