permutation

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...

Hi there, I have just about done my head in searching for a solution to my problem. I have a list of data similar to the following AB BC CD AC AD BD I need to be able to create a list of all possible combinations with a criteria of the first character of the second and each subsequent part of...

Hello, I just joined because I need help with an index generator that I am working on. I have been asked to create an index of all possible combinations of atributes from different sheets. For example, I may have three sheets: Size Sheet Small Medium Large Magnitude Sheet Dark Dim...

Hi, I have a 2D array of size x times y containing texts. Each element may contain either: 1) some texts, 2) the underscore, or 3) nothing. Like this (x=3, y =4): "john" "_" "black" "peter" "" "blue" "mary" "" "" "" "" "" Now i'm looking for a way to 1) ignore empty...

Hi everyone, I have a list of - say 5 events - all independents. Each event has 2 outcomes: failure or sucess with two gains possible : GainFailure and Gainsuccess I want to get a table giving me the gain for each scenario with the associated probability and then chart it. EXAMPLE: (with...

Simply stated, I need a macro that will output all the combinations of 9!/5! There will be 3024 combinations. I don't want a non-repeating combination (like 9C5=126) or a repeating permutation (like 9P5=15120). Can anyone help me here? Thank you in advance.