Need suggestions on netting data

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I have four pieces of data in a securities list

ID, Counterparty, Amount, Market Price.

I need to net the sum of the Amount for every ID per
Counterparty. In many cases there are different
counterparties with the same ID. I can use the subtotals
funtion in Excel, but i can't have results formatted in
that way. I need the results created into another list to
be uploaded. final list would look like

ID Counterparty Net Amount Average Market Price

Any suggestion?
 
Back
Top