permutations/combinations
 

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

permutations/combinations
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ps.com...
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

permutations/combinations
 

See:

http://groups.google.com/group/micro...?output=gplain


--
Gary''s Student - gsnu200745


" wrote:

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