You can use solver (add-in that comes with office)

http://tinyurl.com/4doog

is a link how to do it

--
Regards,

Peo Sjoblom

(No private emails please)


"mellowe" wrote in message
...
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?