- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2004 May
- Permutations

Subject: | Permutations |

Posted by: | Sam Bench (samben…@comcast.net) |

Date: | Sun, 16 May 2004 |

I would like to type six letters across the top of a spreadsheet - one in

each cell.

Then I would like Excel to concatenate the letters into all the permutations

of the letters (i.e. 6 taken 6 at a time, 6 taken 5 at a time, 6 taken 4 at

a time, and 6 taken 3 at a time). This results in about 2000 possible

permutations of the letters. Each concatenation would be in a single cell.

Does anyone have any ideas on how to automate this process??? Thanks in

advance.

- Re: Permutations posted by Frank Kabel on Sun, 16 May 2004