Find combinations of numbers to equal a value

G

Guest

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?
 
B

Bernie Deitrick

jubu,

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
EXCEL FIND A SPECIFIC TOTAL 8
Find numbers in a range that sum up to a specified number 6
Multiple AND OR functions 5
Combining sumIF statements with other functions? 2
Combine an And OR function 4
How can I? 4
Finding the value of x 4

Top