Permutations

Giganews Newsgroups
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.

Replies