View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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