Hello,everyone. Please help me with this problem. I have this worksheet:


PROVINCE
A B C D
E F Ak An Ca
1 Date Personnel Particulars Amount Code Province
2 01/02 Ian Travel 542 1 Ak
542
3 02/01 Mark Tires 150 3 An
150
4 02/03 May Bags 15 2 Ak
15
5 03/05 Loiue Travel 250 1 Ca
250


So I may arrive at this next sheet:

Code As of FEb. This month of Mar. As of Mar.

1 542 250
542
2 15
3 150

The formula goes on the AS OF FEB. and THIS MONTH OF MAR.
Thank you very much if you can help me...
nijins