is there a formula?

[Chamberlain]

I have a column with numbers in it. I would like to see what combination of those cells of numbers would equal to a specific total. I am trying to figure out how someone derived at a particular number using his data.

 

[Peo Sjoblom]

You need to use solver for that,it is an add-in that comes with
excel/office,
for a possible solution see

http://tinyurl.com/27a42

--

Regards,

Peo Sjoblom

I have a column with numbers in it. I would like to see what combination

of those cells of numbers would equal to a specific total. I am trying to
figure out how someone derived at a particular number using his data.