View Single Post
  #1   Report Post  
mellowe
 
Posts: n/a
Default finding cell values

If I have a column of numbers and want to find which of these numbers add up
to a specific value how do you do this using a formula? eg; have values 50,
28,32,19,42 and the sum value is 102. Can you make excel identify the values
that make up to 102 without manually trying to find them yourself?