Match Many to One

T

Tarig

Sometimes I receive checks from customers for settling a number of invoice
(but not all invoices) without mentioning those specific invoices on their
payment slip, is there any way that I can get excel to find the possible
combination of cells contain invoice amounts that sum up to the amount of
customer check?
Example
A B
1 Inv 12 2,450
2 Inv 13 1,500
3 Inv 14 750
4 Inv 15 450
5 Inv 16 3,225
6 Inv 17 1,750

I want excel to fill color/list cells that sum up to 6,475, the result
should be filling color of cell A2, A5 and A6.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top