View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN

Mau-

Tushar Mehta has a template that invokes Solver for this type of problem.
You can download the file from:

http://www.tushar-mehta.com/excel/te...ues/index.html

You'll most likely need to install the Solver Add-In (go to Tools Add-Ins).

HTH
Jason Morin
Atlanta, GA

"Mau" wrote:

I need a formula that allows me to find which numbers in a column make the
one I am looking for.
For example, I am looking for the value 4979,40 in the second column, in
this case is the sum of 4502,45 and 476,95.
Do somebody have an idea?
Thanks.

1 1.203,97
2 4.502,45
3 3.490,37
4 9.799,68
5 476,95
6 367,02
4.979,40