Okay there are about 400 records from which i need to find the combinations.
If I try the code given on the website, the excel goes in a "Not Responding"
mode and I have to 'End Program'

The solver tempalate doesnt seem to work either. It just says too much data.

Are there other options?

Thanks for your help.


"Gary''s Student" wrote in message
...
See:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu2007L


"Gaurav" wrote:

I was asked this question. I did not have the answer of course that is
why i
am posting this here.

"In one column, find all possible combinations of two cells that add up
to
7007.90"

how do we do this?