Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all possible combinations of unique letters
Im not sure if this belongs in the programming DG or the functions DG, but
here goes€¦ I am trying to get Excel to give me all possible combinations of letters. For example, A and B could be combined into A, B, and AB, to yield three combinations. A and B and C could be combined into A, B, C, AB, AC, BC, and ABC, which yields seven combinations. A, B, C, and D yields 15 combinations, and so on and so forth. Id like to get Excel to do this for me for larger sets (specifically, A, B, C, D, and E). I believe the logic would be 2^variables-1. Does anyone have any suggestions? Cordially, Ryan--- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all possible combinations of unique letters
is this what you're looking for
http://j-walk.com/ss///excel/tips/tip46.htm -- Gary "ryguy7272" wrote in message ... I'm not sure if this belongs in the programming DG or the functions DG, but here goes. I am trying to get Excel to give me all possible combinations of letters. For example, A and B could be combined into A, B, and AB, to yield three combinations. A and B and C could be combined into A, B, C, AB, AC, BC, and ABC, which yields seven combinations. A, B, C, and D yields 15 combinations, and so on and so forth. I'd like to get Excel to do this for me for larger sets (specifically, A, B, C, D, and E). I believe the logic would be 2^variables-1. Does anyone have any suggestions? Cordially, Ryan--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all possible combinations of unique letters
Thanks, this is close, but not quite what Im looking for. Below is a sample
of what I am trying to achieve. Three letters, A, B, and C, give the following combinations: A B C AB BC AC ABC I am looking for combinations of A, B, C, D, and E. I believe the final result would be 2^n-1 number of combinations. The J-Walk example is great, but I dont want to find all combinations of all letters, just some kind of subset of combinations, as the example above demonstrates (not exactly sure what to call it). Sorry, I guess the title in my post was misleading. Cordially, Ryan-- "Gary Keramidas" wrote: is this what you're looking for http://j-walk.com/ss///excel/tips/tip46.htm -- Gary "ryguy7272" wrote in message ... I'm not sure if this belongs in the programming DG or the functions DG, but here goes. I am trying to get Excel to give me all possible combinations of letters. For example, A and B could be combined into A, B, and AB, to yield three combinations. A and B and C could be combined into A, B, C, AB, AC, BC, and ABC, which yields seven combinations. A, B, C, and D yields 15 combinations, and so on and so forth. I'd like to get Excel to do this for me for larger sets (specifically, A, B, C, D, and E). I believe the logic would be 2^variables-1. Does anyone have any suggestions? Cordially, Ryan--- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all possible combinations of unique letters
Thanks to all who viewed this question.
I found the answer I was after on an old post: http://www.microsoft.com/office/comm...=en-us&m=1&p=1 "ryguy7272" wrote: Thanks, this is close, but not quite what Im looking for. Below is a sample of what I am trying to achieve. Three letters, A, B, and C, give the following combinations: A B C AB BC AC ABC I am looking for combinations of A, B, C, D, and E. I believe the final result would be 2^n-1 number of combinations. The J-Walk example is great, but I dont want to find all combinations of all letters, just some kind of subset of combinations, as the example above demonstrates (not exactly sure what to call it). Sorry, I guess the title in my post was misleading. Cordially, Ryan-- "Gary Keramidas" wrote: is this what you're looking for http://j-walk.com/ss///excel/tips/tip46.htm -- Gary "ryguy7272" wrote in message ... I'm not sure if this belongs in the programming DG or the functions DG, but here goes. I am trying to get Excel to give me all possible combinations of letters. For example, A and B could be combined into A, B, and AB, to yield three combinations. A and B and C could be combined into A, B, C, AB, AC, BC, and ABC, which yields seven combinations. A, B, C, and D yields 15 combinations, and so on and so forth. I'd like to get Excel to do this for me for larger sets (specifically, A, B, C, D, and E). I believe the logic would be 2^variables-1. Does anyone have any suggestions? Cordially, Ryan--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering unique combinations of cells | Excel Discussion (Misc queries) | |||
Formulas to display all 3 letter combinations in 8 letters | Excel Discussion (Misc queries) | |||
Need possible combinations of 7 unique characters. | Excel Worksheet Functions | |||
Counting unique combinations in two columns | Excel Discussion (Misc queries) | |||
count unique combinations | Excel Programming |