Permutation Output
 

Excel can calculate the possible permutations of 3 items out of a total of 5
items (60 possibilities). This is done easily enough using the PERMUT
function.

My Questiion: Can excel (perhaps using VBA???) ouput all of those
permutations?

For example: TIM, JIM, KIM, RIM, PIM these are the 5 data points. I need
an output listing of all possible permutations of 3 (TIM/KIM/RIM;
RIM/TIM/KIM;PIM/JIM/TIM; etc).

Can Excel do this?

An example

http://j-walk.com/ss/excel/tips/tip46.htm


Regards,

Peo Sjoblom

"Tuna Witch" wrote:

Excel can calculate the possible permutations of 3 items out of a total of 5
items (60 possibilities). This is done easily enough using the PERMUT
function.

My Questiion: Can excel (perhaps using VBA???) ouput all of those
permutations?

For example: TIM, JIM, KIM, RIM, PIM these are the 5 data points. I need
an output listing of all possible permutations of 3 (TIM/KIM/RIM;
RIM/TIM/KIM;PIM/JIM/TIM; etc).

Can Excel do this?

Thanks for the help. I can use that algorithm, though it will need to be
modified to return only the combinations of three characters, not the
individual letter combinations of each three character string (there were
over 65000 of these!)

Any idea on how to modify so that it will return what I need?

thanks

"Tuna Witch" wrote:

Excel can calculate the possible permutations of 3 items out of a total of 5
items (60 possibilities). This is done easily enough using the PERMUT
function.

My Questiion: Can excel (perhaps using VBA???) ouput all of those
permutations?

For example: TIM, JIM, KIM, RIM, PIM these are the 5 data points. I need
an output listing of all possible permutations of 3 (TIM/KIM/RIM;
RIM/TIM/KIM;PIM/JIM/TIM; etc).

Can Excel do this?