Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |