View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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?