combination of numbers

[RichardO]

Hello all:

I was wondering if it is possible to do the following in excel:

In column C with row 1 being the header, I have some amounts i
dollars.

I have a number in column D e.g. $320,000. Can I tell excel to give m
the combination of the cells in column C whose sum comes up t
$320,000.

E.g.
20000
30000
100000
50000
150000
25000
35000
40000
5000
80000

so there 1 combination could be:
C2, C4, C5 & C6
Another combination could be:
C4, C5, C7, C8, C11
and other combinations exist.

Is it possible to do this? Or should I be posting this in th
Programming forum?

Thanks so much for taking time to help.


Richard

 

[Harlan Grove]

I have a number in column D e.g. $320,000. Can I tell excel to give me
the combination of the cells in column C whose sum comes up to
$320,000.

....

See the thread beginning at

http://groups.google.com/[email protected]