View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
kraljb
 
Posts: n/a
Default =combin function


The combin function doesn't necessarily show you that. At least from
what your samples how. the combin function would think the following
values are counted as 1, because it's only looking at items, not at
order
abcd
abdc
acbd
As these only the order is changing

Also, the combin function does not take into account repeats of the
same item so the following would not be introduced into the system at
all
aaaa
aaab
aabb
And with this as it won't repeat values
So while combin(10,4) returns 210, that is missing quite a few values.
The more appropriate way to calculate it the way that it appears you
want done. Would be =combin(10,4)*4^4 which equals 53760 and as the
list is already that big it doens't leave much room for growing beyond
the limitations of excel. Just going from combin(10,4) to combin(10,5)
it raises from 210 to 252, while combin(10,5)*5^5 jumps up to 787500
(Which would be just over 12 columns completely filled with numbers).

But to do it with just the 210, or 252 you would need to setup a macro
for that. Either way it is "doable", but if you want the full list, you
may want to go out of town for a few days while Excel does the work once
you have a macro.

Hope that helps


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=515435