Hi,

Please help me with this.
I have a spreadsheet which looks like this. The dataset has been sorted by Customer ID.

Date----------customer ID---------profit/(loss)
01/01/11-------123-----------------------(30)
02/01/11-------123------------------------10
02/01/11-------123------------------------20
02/01/11--------456----------------------(40)
04/01/11-------456-----------------------30
04/01/11--------567-----------------------(50)

I want to aggrgate profits and losses seperately on a specific date. That is I need to arrange the above dataset in the following way.

Date---------------Profit-----------------Loss
01/01/11----------------------------------(30)
02/01/11-----------30-------------------(40)
04/01/11-----------30-------------------(50)

Pls pls help me

Thank you........