Finding combinations of 8 letters

**macaonghus** · 02-10-2010, 09:39 AM

I have eight letters (LHWMPISA), and I need to generate all the combinations, specifying the size of the subset. e.g. all combinations that include 5 letters.

How can I do this?

I've looked through all the past threads and tried the answers, including Myra's code, but can't get this to work.

**stanleydgromjr** · 02-10-2010, 11:29 AM

macaonghus,

See the attached workbook "Find combinations of 8 letters - macaonghus - SDG11.xls", with macro "ListPermutationsOrCombinations", by Myrna Larson.

Detach/open the workbook, and run the "ListPermutationsOrCombinations" macro. The macro will run in either Excel 2003 or 2007.

It will create Sheet2 with the list of 5 letters.

**macaonghus** · 03-07-2010, 02:28 PM

Brilliant, thank you so much!

**sammysore** · 02-19-2015, 02:18 AM

Hi Is this possible to do for AAAA.

The result would look like
AAAA AABA AACA AADA
AAAB AABB AACB AADB
AAAC AABC AACC AADC
AAAD AABD AACD AADD
AAAE AABE AACE AADE
AAAF AABF AACF
AAAG AABG AACG
AAAH AABH AACH
AAAI AABI AACI
AAAJ AABJ AACJ
AAAK AABK AACK
.
.
.
.
.
.
.
AAAZ AABZ AACZ . . . . . . . . . . . . . . . . . ZZZZ

thanks for the reply!

**FDibbins** · 02-19-2015, 02:20 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.