Hi, is there a way to find which of a list of values in cells that add up to a given figure? ie if I cells 1 to 5 with 10,20,30,40,50 and I need to know of thise five which add up to 70.
thanks Darren.
finding a value form a combination of figures
-
- 3StarLounger
- Posts: 313
- Joined: 04 May 2010, 15:18
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: finding a value form a combination of figures
As you can see in your example, there can be multiple solutions:
10+20+40 = 70
20+50 = 70
30+40 = 70
Do you want to find ALL solutions, or a solution using as few values as possible, or a solution using as many values as possible, or just any solution?
10+20+40 = 70
20+50 = 70
30+40 = 70
Do you want to find ALL solutions, or a solution using as few values as possible, or a solution using as many values as possible, or just any solution?
Best wishes,
Hans
Hans