How To Find All Combinations That Equal A Given Sum

[shophoney]

Hi,

I am trying to reconcile our PayPal account.

Unfortunately Paypal deposits funds not at the end of each day but when funds are released from your credit card or bank this can mean funds for one transaction arrive 5 days later and others 30 days later.

Every few days I get a large deposit with no details. I'm looking to create a way to see which transactions above add up to the amount of the deposit.

I've tried using Excel Solver, but it's a lot of manual work for my staff to keep changing the range of the cells to review.

What I've seen is that line 1, 5, 22, 23... Can be a deposit. Then line 2,3,4,8,30 could be the next.

Any ideas would be great.

 

[Ezguy4u]

I have a bank account where money is being withdrawn and deposited. My suggestion is to color the cell you want to observe. I color the cells using a program. Once the cells you want to high light are colored than you can insert and table the array. I then filter on that color. At that point you should be seeing only General Withdrawal. If nothing else, this should get a discussion going.

 

[Anthony47]

See and check if what I published in this discussion can be reused: Vba?

Bye

 

[narendra]

you may want to check out this file which used a vba solution..

Accounts Receivable Challenge from August 2002

Hi everyone. I have to solve a problem jult like the one that originated this challenge of the month. I copied Ioannis macro, but I can't find out how to get it to work Where do I input the ammount of the check recieved? Widn one of the 4 macros do I have to run? How do I have to set the data...

www.mrexcel.com

It was a winning entry to an Aug 2002 Accounts Receivable Challange.

Accounts Receivable Challenge

www.mrexcel.com

 

[NdNoviceHlp]

Hi shophoney. I've got some code for U to trial if the above doesn't work. There may be more than 1 set of possible combinations so do you have an empty column for displaying the different combos? Also, an unused cell will be needed if U have an unused cell address. If you could provide a blank XL file containing data for testing, that would also be helpful. Dave

 

[pedro-egoli]

Check out this thread Looking for a sprecific sum within a range
My attempt

File to ascertain individual amounts that make up total.xls
	A	B
1	14.56	1
2	19.51	0
3	105.64	1
4	100.91	1
5	21.6	1
6
7	262.22	242.71
8	-19.51
9	242.71
Sheet1

Cell Formulas
Range	Formula
A7	A7	=SUM(A1:A6)
B7	B7	=SUMPRODUCT(A1:A5,B1:B5)
A9	A9	=SUM(A7:A8)