| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find values that add up to certain amount
I have a long list of monetary amounts listed on an excel spreadsheet. I am
trying to find combinations of those amounts that add up to certain larger sums. For example on a smaller scale: 10 15 21 41 53 How can I find the cells that add up to 108? Is there a formula or function I can use on a large scale for this type of thing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find averages not including 0's for values not in contiguous rows or columns | Excel Worksheet Functions | |||
| find the max values for cells in consecutive groups of 600 | Excel Discussion (Misc queries) | |||
| in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions | |||
Threaded Mode
