R
ryguy7272
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---
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---