Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The function combin(22,6) produces 74,613 combinations.
However, I have an excel program which eleminates the majority of the combination because it allows not more than 2 numbers in each subset to be repeated. This results in a total of 77 combinations that meet the criteria. Example: 1,2,3,4,5,6 1,2,7,8,9,10 1,2,11,12,13,14 1,2,15,16,17,18 1,2,19,20,21,22 1,3,7,11,15,19 1,3,8,12,16,20 How can the combin function be manipulated to show the result of 77? For testing purposes =combin(23,7) produces 245,157 combinations but when not more than 3 numbers are allowed to repeat the result is 253 combinations that meet the criteria. Dk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COMBIN | Excel Worksheet Functions | |||
Combin | Excel Worksheet Functions | |||
=combin function | New Users to Excel | |||
=combin function | New Users to Excel | |||
Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) |