View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeffrey Marcellus Jeffrey Marcellus is offline
external usenet poster
 
Posts: 7
Default Combination Determination?

Hi, I was wondering if anyone had written, or can think of an easy
algorithm which can determine what combinations of units will fall in a
certain range. For instance, if I gave it sections of flooring that were 1m,
2.5m, 4m, and asked for all combinations which would fall between 4.5m & 5m,
it would return an array with 5x1m,1x2.5m + 2x1m, 1x4m + 1x1m.
Thanks, Jeff