catherinemoore
New Member
- Joined
- Oct 10, 2006
- Messages
- 10
I have the following problem. I have a spreadsheet which I have taken a sample from below:
NUM TRANSTYPE TRANSDATE CURBAL
685BI REC 09/10/2006 13:22 8
685BI PCOUNT 09/10/2006 13:22 8
685BI REC 16/08/2006 13:50 8
685BI PCOUNT 16/08/2006 13:50 0
685BI INSERT 28/03/2006 13:29 0
686BJ REC 16/08/2006 13:51 7
686BJ PCOUNT 16/08/2006 13:51 0
686BJ INSERT 28/03/2006 13:34 0
For each unique NUM I need to take perform the following calculation: (CURBAL for TRANSTYPE PCOUNT with latest TRANSDATE) - (CURBAL for TRANSTYPE REC with latest TRANSDATE).
Does anyone have any ideas? I've tried using a Pivot Table and Subtotals, but can't seem to get anything near what I need.
Thanks.
NUM TRANSTYPE TRANSDATE CURBAL
685BI REC 09/10/2006 13:22 8
685BI PCOUNT 09/10/2006 13:22 8
685BI REC 16/08/2006 13:50 8
685BI PCOUNT 16/08/2006 13:50 0
685BI INSERT 28/03/2006 13:29 0
686BJ REC 16/08/2006 13:51 7
686BJ PCOUNT 16/08/2006 13:51 0
686BJ INSERT 28/03/2006 13:34 0
For each unique NUM I need to take perform the following calculation: (CURBAL for TRANSTYPE PCOUNT with latest TRANSDATE) - (CURBAL for TRANSTYPE REC with latest TRANSDATE).
Does anyone have any ideas? I've tried using a Pivot Table and Subtotals, but can't seem to get anything near what I need.
Thanks.