View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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