I am putting together an Excel program that will do some very interesting calculations and I am duped on how to set up a particular program for what I need accomplished. If you could assist me with this problem I would be eternally grateful. Here is what I need:
Lets say that I have a series of numbers (ex. 40,11,18,29,22,8, etc.)
Lets say I assign to each of these numbers a letter designation (H or C)
Now lets say that I want to create a program that will tell me the difference combinations that I can get from a group of numbers when I select a particular pattern for these numbers. For example, lets say that for the numbers that are selected I want a pattern that gives me all the different combinations for those numbers that meet the criterion of:
HHCCHH, or (40=H; 11=H; 18=C; 29=C; 22=H; & 8=H)
HHHCCC, or (40=H; 11=H; 18=H; 29=C; 22=C; & 8=C)
HCCHCC, or (40=H; 11=C; 18=C; 29=H; 22=C; & 8=C), etc.
Lets say that I have a series of numbers (ex. 40,11,18,29,22,8, etc.)
Lets say I assign to each of these numbers a letter designation (H or C)
Now lets say that I want to create a program that will tell me the difference combinations that I can get from a group of numbers when I select a particular pattern for these numbers. For example, lets say that for the numbers that are selected I want a pattern that gives me all the different combinations for those numbers that meet the criterion of:
HHCCHH, or (40=H; 11=H; 18=C; 29=C; 22=H; & 8=H)
HHHCCC, or (40=H; 11=H; 18=H; 29=C; 22=C; & 8=C)
HCCHCC, or (40=H; 11=C; 18=C; 29=H; 22=C; & 8=C), etc.
