Hello..
Here's a comparison for the result.
exclpic.xls is the temporary result.
wiw.xls is the result I want.
I hope you notice the differences:
1. The dates are in ascending order, no matter where it takes. Either from "Buy" or "Sell", they're put in ascending order.
2. If there more than 1 inputs on the same date, either "Buy" or "Sell", the data will be put in different rows. ie: row 4 and 5 (26 Mar). row 9 and 10 (29 Mar).
3 And most importantly, there are no Input and Output in the same row. In C2, the total 74.625.500 which is from "Buy" went to Ouput.
The same total from "Buy". All went to Output. (C4, C5, C6, C7, C8).
4. For the Input, 75.600.000 in B3 is from "Sell". Please notice the right side of B3 is empty, as the left side of C2 is empty. It's because Input means profit which we got from "Selling", whilst Output means "Buying" the products.
Sorry to confuse you with my language.
Bookmarks