Shark

I've got a sales accounts thats in a mess and can't work out which invoices are paid by the cheque. The customer is, well not very helpful.

I have 20 invoices and one cheque. Not sure what combination to put the invoices in to reach the cheque figure - can excel work this out for me?

Cheers

David

MrDeference

Does it have to be Excel? You want to find which combination of x out of the 20 invoices comes up with the total which is written on the cheque?

Puff The Magic Wagon!

iTrader: (2)

Email me the figures & I'll work it out for a small fee

Got some time on my hands

dsmith

I have a working solution - bit messy but functional.

I'll mail an example.

Deano

dsmith

No I won't

Doesn't work beyond a few lines trivial example.

MattN

I'm an expert in Excel.

Mail me the figures

MrDeference

Cos I was bored.
IF you have IE 5 or above. See if this helps.
Put your numbers in the box top box one per line, and then put the target in the next one.
Click "Button"
If there is a match it will show you...

Bug reports you can shove up your ... ahem

EDIT: More accurate useage instructions...
EDIT: Removed the link. Will post again tomorrow if there is any interest from Mr Shark.

[Edited by MrDeference - 10/14/2002 11:10:53 PM]

russell hayward

**** me, just add up the pence digit on some of the invoices and you will soon see which ones they are

Presumably the dates should help too assuming they are not all in the same month

New User

If the customer aint telling you which invoices hes paying, allocate the cheque against the oldest one first.