Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the fewest values to equal a set total
I have 5 parts with a thickness of 1, 3, 5, 8, and 10. I need to figure out
the fewest parts that will equal a total thickness of any given number. If I need a total thickness of 235, what's the smallest combination of 10s, 8s, 5s, 3s, and 1s that will get me to this total? (23 tens, and 1 five). I need to plug in any number for the total thickness and figure out the fewest possible parts to get me there (and the quantities of each). Can this be done in Excel and how? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
How to:Find the row of the first cell not equal to several values | Excel Worksheet Functions | |||
find all employees whose total salaries equal a given amount | Excel Discussion (Misc queries) | |||
Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions |