Unfortunately, 100 items can have 10^30 combinations. I don't know of good
method.

"Handsy11" wrote:


Yeah I know where your coming from....I only had less than two hundred
data points and six totals to calculate to start with....I have done
the majority of the work manually and so am only left with less than
one hundred data points and four totals so a macro might be
useful.....I am familiar with Vb but have never written a
macro.....Could anyone guide me as to how I might write a macro to
solve this problem??


--
Handsy11
------------------------------------------------------------------------
Handsy11's Profile: http://www.excelforum.com/member.php...o&userid=25098
View this thread: http://www.excelforum.com/showthread...hreadid=386086