Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |