If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel -
Is there a way to check through a group of numbers and pick out the
ones that total a figure. Eg: I have a value of $20,554.00 An the following credits, of which some of these values total the $20,554.00. Is there a function in Excel to highlight the combination of figures? Thank you. (11,998.00) (8,894.00) (8,000.00) (6,654.00) (556.00) (554.00) (225.00) (5,542.00) (6,665.00) |
#2
|
|||
|
|||
Excel -
Google for Solver
"luendab" wrote: Is there a way to check through a group of numbers and pick out the ones that total a figure. Eg: I have a value of $20,554.00 An the following credits, of which some of these values total the $20,554.00. Is there a function in Excel to highlight the combination of figures? Thank you. (11,998.00) (8,894.00) (8,000.00) (6,654.00) (556.00) (554.00) (225.00) (5,542.00) (6,665.00) . |
#3
|
|||
|
|||
Excel -
Hi,
You have a fundamental problem with this in that your looking for a positive amount and all your data are negative amounts so there is no solution for the example you posted. You therefore have choices, you can change you data to positive or the total yur looking for to negative. If you do that and follow the guidance in the thread below then you should find a solution http://groups.google.com/group/micro...3c842d362f7 b -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "luendab" wrote: Is there a way to check through a group of numbers and pick out the ones that total a figure. Eg: I have a value of $20,554.00 An the following credits, of which some of these values total the $20,554.00. Is there a function in Excel to highlight the combination of figures? Thank you. (11,998.00) (8,894.00) (8,000.00) (6,654.00) (556.00) (554.00) (225.00) (5,542.00) (6,665.00) . |
Thread Tools | |
Display Modes | |
|
|