|
|
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?
|