Exchange rate loss & gain

irksy

New Member
Joined
Jul 10, 2013
Messages
29
HI All

Trying to build a loss gain report for my company based on exchange rates at invoice issue and receipt of funds, however, as some payments contain multiple invoices I have hit a stumbling block;

Sheet3

*ABCDEFGHIJKLM
1Receipt No.Receipt DateNumber ReceivedExch Rate USDInvoice No.Invoice DateNumber AmountExch Rate USDDifference
2RC14900001409/01/201441648 € * * * * * * * 20,649.241.3590100 $ * * * * *28,062.52SI13600056827/11/201341605 € * * 1,707.591.3564400 $ * * * * * *2,316.24*
3RC14900001409/01/201441648 € * * * * * * * 20,649.241.3590100*SI13600057027/11/201341605 € * * 4,438.701.3564400 $ * * * * * *6,020.83*
4RC14900001409/01/201441648 € * * * * * * * 20,649.241.3590100*SI13600058202/12/201341610 € * * 1,789.761.3550100 $ * * * * * *2,425.14*
5RC14900001409/01/201441648 € * * * * * * * 20,649.241.3590100*SI13600060420/12/201341628 € * 12,713.191.3671500 $ * * * * *17,380.84*
6RC14900001210/01/201441649 € * * * * * * * * * * 309.821.3663500 $ * * * * * * * *423.32SI13600058911/12/201341619 € * * * * 309.821.3793200 $ * * * * * * * *427.34*
7RC14900001313/01/201441652 € * * * * * * * * 1,103.131.3645200 $ * * * * * *1,505.24SI13600060018/12/201341626 € * * 1,103.131.3762800 $ * * * * * *1,518.22*

<tbody>
</tbody>


So what I need to do in difference (column M) is minus column L from column F but I need the top four results with the same Receipt No. (Column A) so L2 L3 L4 and L5 to all be taken away from F2.

The above is only a small snippet of the overall table so want to make it as easy as possible.

Excel tables to the web >> Excel Jeanie HTML 4
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top