| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate all possible combination from 10 variables
Well.. ahhhh.... Andrew's excellent code is 5 times faster on a larger
set!! I really thought the loop version would be faster vs. recursion with strings. I tried the problem with 24 items, and searching for subsets with 2-5 items. The number of solutions is 55,430, so it fits within 1 column in Excel. Again, Andrew's excellent code is 5 times faster here. Thanks Andrew. :0 -- "To understand recursion, one must first understand recursion." Dana DeLouis Windows XP, Office 2003 <snip |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to calculate percentage with some variables | Excel Worksheet Functions | |||
| How do I calculate maximum with variables. | Excel Worksheet Functions | |||
| combination charts: two variables in one series? | Charts and Charting in Excel | |||
| Is there an easy way calculate 2 variables in conditional sum wiz. | Excel Worksheet Functions | |||
| calculate the derivative (rate of change) of variables | Excel Programming | |||
Threaded Mode
