View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Freddy[_5_] Freddy[_5_] is offline
external usenet poster
 
Posts: 1
Default easy problem for programmers

As I'm no programmer I need help from you. I have a column
with a range of values (amounts). In a second column I
have only 1 amount(total). Now I want to know every
combination of amounts from the first row that added
together equals the total amount of the second row. It may
be a combination of 2, 3 or more values. The combinations
that match should be copied to a new column. I hope I made
myself clear. How can this be done ? Thanks.