S
Sam Bench
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.
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.