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.
(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.