formula for finding numbers that add up to a spicific number
in [General]
|
From: Aljar on 28 Apr 2010 12:03 I have a cloumn of numbers. I need a formula that will select 4 of these numbers that add up to a known number. example: column C has the following numbers 4, 8, 12, 6, 21, 28, 17, 20, 24 I need to for of these numbers that add up to 50 What formula can I use? -- Aljar
From: Eduardo on 28 Apr 2010 12:13 Hi, Look here http://www.tushar-mehta.com/excel/templates/match_values/index.html "Aljar" wrote: > I have a cloumn of numbers. I need a formula that will select 4 of these > numbers that add up to a known number. > example: > column C has the following numbers 4, 8, 12, 6, 21, 28, 17, 20, 24 > I need to for of these numbers that add up to 50 > What formula can I use? > -- > Aljar
|
Pages: 1 Prev: how i fix a corupted excel worksheet. Next: Vlookup with 3 viariables |