MicrosoftSergeiBaklan There is list of Freight slips in database running in thousand of entries. Out of those slips, only "Ex Works" slips have been filtered as freight for those slips is to be claimed from the consignee directly. Instead of introducing additional columns in main database, we extracted the required part from the main database and entered receipt details in Column R, S and Column T to get the balance payment to be received.
Currently we are having only 3 such records.
Column L represent freight to be Received from party
Column R represent the first installment received from party against freight
Column T represent the final balance amount received from party.
So Column U is supposed to be representing balance payment received from party.
So Balance payment in above cases should be 37700 (37800-100), 32200 (32400-200) and 950 (1250-300)
But 100 is getting deducted from all the rows as I have no way to change that -$R6-$T6 portion in Dynamic array formula. So for row number 7 and 8, amount appearing in row 6, i.e., 100 is being deducted.
And for all formulas shown, for U6,U7 and U8 you deduct R6 and T6 (not R6-T6, R7-T7, etc), thus the result looks correct.
The formula in RED is showing the formula used in Column U.
I tried it with DAF as that can get rid of manually extending the formula range and automatically expands to cater to the extended range.
Hope I am clear.
And for all formulas shown, for U6,U7 and U8 you deduct R6 and T6 (not R6-T6, R7-T7, etc), thus the result looks correct.
I wish I could do that. But as U6, U7 and U8 contain DAF, I can enter the formula in Cell U6 only and then it auto populates
BTW: Where can I study the DAF documentation. I feel I don't still understand the concept properly.
Is there any difference between Spilled array Formulas and Dynamic array formulas ?
Regards
Kanwaljit
