| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
| Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Linear Mode
