Hi I have a data set where each order ID has different settlement values. There are duplicate order ids with different settlements amounts which need to be summed
<tbody>
</tbody>
In tab 2
<tbody>
</tbody>
Need to lookup the order id's and sum them under net settlement
Could someone please help
order id | net settlement | |
<tbody> </tbody> |
<tbody>
</tbody>
In tab 2
order id | settlement |
OD105630099701460000 | 945 |
OD105630099701460000 | -900 |
OD105630099701460000 | 25 |
<tbody>
</tbody>
Need to lookup the order id's and sum them under net settlement
Could someone please help