You can use Solver:

http://www.tushar-mehta.com/excel/te...olver_Template
--
Gary''s Student - gsnu200768


"Michael" wrote:

Help please...

I have a single column of data that is over 256 rows. They are dollar
amounts and I am looking for every possible combination of the numbers that
equal a specific dollar amount. It could be that is only a sum of two
numbers or it could be three, four or five or more, however, 95% of the time
it is only the sum of two numbers. I haven't been able to figure out from
the help feature how to solve this problem. I was manually doing it by
copying the data and transposing it but this only works when I have less than
255 rows.

A simple example of my problem would be this...
My data:
1
2
3
4
7
and I am looking for every possible combination that gives me 9. Easy to do
in my head but I can't when I have so many rows.

Anyone able to guide me on this?

Thanks in advance.