Calculate which values = specific amount

**markswan20** · 12-21-2009, 09:30 AM

Hi to All,

I have attached basic worksheet to detail my problem further.

I have many customers that pay balances each month that never tell me which invoices they pay.

Is it possible for excel to work out which values = a specific figure given?

Many Thanks
Mark

**martindwilson** · 12-21-2009, 09:38 AM

you can use solver!

**dominicb** · 12-21-2009, 09:39 AM

Good morning markswan20

Originally Posted by markswan20

I have many customers that pay balances each month that never tell me which invoices they pay.
Is it possible for excel to work out which values = a specific figure given?

This kind of question pops up on the forum from time to time. Have a look at this thread : it details a couple of ways to go with the problem.

HTH

DominicB

**teylyn** · 12-21-2009, 09:40 AM

pulling up a chair to watch ....

Martin , can you elaborate? As in how to find solver and what to do with it once you've found it ?

cheers