Hi All,
As my pursuit to invent a template for computing foreign exchange gains on Financial Instruments using FIFO continues, i have made a bit of progress.
However, there is one challenge, i am trying to allocate a weighted average rate for the sales during the year for unique instruments (derived from column P & Q) to the matched sales in column M.
I have tested this with a similar scenario but for one instrument and it works just fine.
Please assist me with a formula to replicate whatever was done for one instrument but this time with different instruments thus requiring a condition.
Both excel samples and details have been attached.
As my pursuit to invent a template for computing foreign exchange gains on Financial Instruments using FIFO continues, i have made a bit of progress.
However, there is one challenge, i am trying to allocate a weighted average rate for the sales during the year for unique instruments (derived from column P & Q) to the matched sales in column M.
I have tested this with a similar scenario but for one instrument and it works just fine.
Please assist me with a formula to replicate whatever was done for one instrument but this time with different instruments thus requiring a condition.
Both excel samples and details have been attached.