LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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---

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering unique combinations of cells John T Kennedy[_2_] Excel Discussion (Misc queries) 8 April 27th 23 07:44 PM
Formulas to display all 3 letter combinations in 8 letters Mally Excel Discussion (Misc queries) 1 December 25th 08 04:34 PM
Need possible combinations of 7 unique characters. scottgorilla[_2_] Excel Worksheet Functions 4 August 21st 08 05:27 PM
Counting unique combinations in two columns [email protected] Excel Discussion (Misc queries) 3 May 6th 07 03:03 AM
count unique combinations mini Excel Programming 2 June 6th 06 12:46 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"