How to find all combinations that equal a given sum in Excel by either a formula or VBA

[jbstream09]

Hi, I'm trying to find a way to find all combinations that equal a given sum in Excel by either a formula or VBA.
I have column A, row A1 through A1750 with different amounts (some are negative amounts) and I need to find which rows add up to the sum of $213,448.63

Please help if you know a way..
Thanks,
JB

 

[Eric W]

This is actually a pretty tough problem (as you can guess based on the few responses so far). I don't have anything personal to offer, but here's a link to a VBA macro that does what you ask:

http://www.mrexcel.com/pc09/

It's from a challenge on this forum from about 15 years ago. I don't know what your VBA skills are, but after I loaded the program into my version of Excel, I had to do some minor tweaking to get it to work. But it did work! So if you have some basic skills, you should be able to get it to work.

Good luck!

 

[traifbest]

Hi, I have a similar problem and looked at the link you provided. I tried all 3 methods in the post, but I could not make it work with my data. Do you know if there are example files of those 3 methods? That way I can see if I make some errors.