racerchamp7
New Member
- Joined
- Mar 21, 2012
- Messages
- 1
Hello, I've tried to search for a solution to this problem, but I cannot seem to come up with one. Any help would be much appreciated.
What I have is a list of 17 characters that I want to generate permutations for. Ultimately, I would like to generate permutations of five-member strings. For example, let's say I have the characters ABCDEFGHIJKLMNOPQ -- I want to generate all permutations of these such as ABCDE, AJFQB, GHOAB, etc. I would also like to be able to hold certain positions constant, such as B always being in the second position such as ABCDE, CBJIH, NBPEF, etc. Letters can also be reused (i.e. AAADH, FJKFF, CCCCC, etc.).
I know this is likely not an easy solution, but is this possible to do with Excel, and how would I do it? I apologize, but I am not well versed in programming in general.
Again, I would very much appreciate any help.
What I have is a list of 17 characters that I want to generate permutations for. Ultimately, I would like to generate permutations of five-member strings. For example, let's say I have the characters ABCDEFGHIJKLMNOPQ -- I want to generate all permutations of these such as ABCDE, AJFQB, GHOAB, etc. I would also like to be able to hold certain positions constant, such as B always being in the second position such as ABCDE, CBJIH, NBPEF, etc. Letters can also be reused (i.e. AAADH, FJKFF, CCCCC, etc.).
I know this is likely not an easy solution, but is this possible to do with Excel, and how would I do it? I apologize, but I am not well versed in programming in general.
Again, I would very much appreciate any help.
