| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I determine which data in a range add up to a fixed number?
How do i take a range of numbers and determine which numbers in the range add
up to 120? or as close to it as possible? I have list of 67 numbers totaling 710. I need to know which combination will add to 120 or as close to it as possible, remove the first result, and repeat it until I have used all the numbers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scatter PLotting using Data in third colum to determine range | Charts and Charting in Excel | |||
| Determine payback period to reach fixed dollar amount. | Excel Worksheet Functions | |||
| lookup range of numbers; return corresponding data for the fixed r | Excel Worksheet Functions | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Threaded Mode
