Excel -

  • Thread starter Thread starter luendab
  • Start date Start date
L

luendab

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)
 
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/micr...+to+one+number&rnum=28&hl=en#44e83c842d362f7b

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top