Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMMON NUMBERS | Excel Worksheet Functions | |||
find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
Random Numbers with certain numbers more common than others | Excel Worksheet Functions | |||
I still cant get the six most common numbers to come up | Excel Discussion (Misc queries) | |||
Common Numbers Formula | Excel Worksheet Functions |