View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Total Common Numbers

Hi,

I want to produce ALL the combinations of C(n,k) where "n" is 12 and
"k" is 4 in an array or memory so to speak because I do not need the
combinations written to the worksheet.
I then want to loop through each one and compare it to the 6 number
combinations in the range "B3:G20", if it has 2 or MORE numbers in
common add 1 to the total.
Once any combination in memory has matched 2 or MORE numbers in common
with ANY 6 number combination then add 1 to the total and move to the
next combination in memory. This is because I only want it to count 1
instance of the 2 or MORE numbers in common with the 6 number
combinations, NOT all instances.
I think maybe a Boolean variable needs to be used.

Thanks in Advance.
All the Best.
Paul