Find combinations of numbers to equal a value
 

I have a list of individual dollar amounts that together total $1000. Is
there a way to have Excel find a combination that would equal $800 and show
me which lines it chooses?
--
jubu

jubu,

Contact me privately and I will send you a workbook that does what you want.

HTH,
Bernie
MS Excel MVP

"jubu" wrote in message
...
I have a list of individual dollar amounts that together total $1000. Is
there a way to have Excel find a combination that would equal $800 and
show
me which lines it chooses?
--
jubu