Finding maximum qty of items to reach given limit

G

Guest

I have a two columns containing items with differents costs and I have two
cells with a Qty of $100 ea., My question! Is there a way to calculate the
maximum number of items I can get with the first $100 and then the next $100,
without repeating an item and then listing which items they are.
 

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

find value in A, grouped to B 1
how to put qty & date of the item 0
Calculating a Formula Subject to a Maximum and Minimum Value 2
Range of data in Excel 1
Can I transpose data from rows to cols with a formula not pivot ta 1
Using STDEV to evaluate a subset of a population 6
Basing math on duplicate entries in a formula 1
Outlook Cannot move the items outlook.pst has reached its maximum size 6

Top