Posted to microsoft.public.excel.programming
|
|
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
|