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
|