Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MATCH AMOUNT FIFO METHOD & INSERT ROWS WHERE EVER REQUIRED.
I have a spreadsheet having two ranges (1) deduction range (2) remittance range
since remittance is not made correctly I need to match remitance to deduction range (FIFO method) and insert a row in the deduction range, if required. sample as follows. ie c1 the first remittance is Rs 200 to be matched with ded (d1 to d4), but for d4 is short by 50 which will be matched with c2 remittance. similarly c2 Rs 300 will be matched with d4 to d6 and short will be matched by c3, like wise. DEDUCTION RANGE MONTH DED REF DED REMIT REF MATCHED REMIT AMT JAN D1 25 C1 25 JAN D2 50 C1 50 JAN D3 75 C1 75 JAN D4 100 C1 50 JAN D4 C2 50 FEB D5 125 C2 125 FEB D6 150 C2 125 FEB D6 C3 25 FEB D7 175 C3 175 MAR D8 200 C3 200 REMITANCE RANGE S No REMIT REF REMIT AMT 1 C1 200 2 C2 300 3 C3 400 I have approx.6000 rows to match for 375 rows Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH INDEX formula required. | Excel Worksheet Functions | |||
Combo Box - Match Required help | Excel Programming | |||
Problem w/ Match prop vs. Match method | Excel Programming | |||
FIFO method calculations | Excel Programming | |||
Combo box match required | Excel Programming |