Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
For account reconcilation purposes...
Basically, given a list of up to 50 numbers (each cell contains a number), the goal is to find 1-5 numbers from that list that add up to a single sum. So if 5, 10, 15, 20, 1, 2, 18, and 3 were on my list, and I wanted to know what adds up to 18, it would return the following combinations of numbers from my list add to 18: 18 5, 10, and 3 5, 10, 1 and 2 15, 1, and 2 15 and 3 I don't need it to identify which cells contain these numbers, just tell me which numbers from my list add up to the sum I give it. A program to identify it would be nice, but not necessary. A few more things: 1.) The program should not use the same cell twice in the caluculation. (So it should not tell me that 5, 5, 5, and 3 make 18, if 5 is only listed once in my list. It could if the number 5 occurs in 3 different cells. 2.) I should be able to change how many numbers it tries to combine. (so I can limit it to only comparing 2 numbers, or increase it up to finding up to 5 numbers that add up to a specific total.) 3. I should be able to control which numbers from the list are compared. 4.) The program should not subtract numbers to get the total requested. Mission Impossible? Or just complicated? I've heard there's ways to make solver do this, but I haven't found a solution yet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Force excel to open on a specific sheet | Excel Worksheet Functions | |||
Opening A Specific Excel Sheet | Excel Discussion (Misc queries) | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
hyperlink to specific sheet in excel | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |