Match Many to One
 

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.

--
tarig

Match Many to One
 

See:
http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu201001


"Tarig" wrote:

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.

--
tarig