| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a sum of a combination of cells to equal a value
I have a maths problem which i am trying to solve with a macro.
I have a list of numberin column A such as 12 14 45 24 85 78 5 33 If i have a value lets say 62 which is the sum of two or more values in the list i would like the macro to place a formula under the list of values adding the cells which make up that total. 62 is made of 33+5+24 this would be formula i would want placed under the list. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find what cells equal a certain number? | Excel Discussion (Misc queries) | |||
| find combination of cells that equal a sum | Excel Worksheet Functions | |||
| How can I find the equal cells in Excel | Excel Discussion (Misc queries) | |||
| Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Threaded Mode
