permutations/combinations

[joe.engel]

Is there a way to list the possible permutations/combinations? Ex.
Combin(4,3) equals 4. With the numbers being 1,2,3,and 4. Have excel
list the combinations as 123, 134, 234, and 124 into certain cells.
Thanks, Joe

 

[Bernard Liengme]

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

You will find more it you Google excel newsgroups - this is a reoccurring
topic
best wishes

 

[Guest]

See:

http://groups.google.com/group/microsoft.public.excel.misc/msg/2150eee92452c83c?output=gplain