Would this be an array or...?

[Michael]

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.

 

[Gary''s Student]

You can use Solver:

http://www.tushar-mehta.com/excel/templates/match_values/index.html#Solver_Template

 

[iliace]

I like the code posted here. It works quite well.

http://groups.google.com/group/micr...9/dd388ae8f0d47c87?lnk=st&q=#dd388ae8f0d47c87

 

[Gary''s Student]

Thanks for the tip...Harlan Grove is a great master of Excel.