Add different Coloumn data with different condition in Daily P&L Col

[AshishAgarwal]

I am trying to below highlighted data in "Daily P&L Coloumn" but not sure how I can proceed.

Example attached.

I would like to add IRS to CCY in Daily P&L Coloumn

[atcodedog05]

Hi @AshishAgarwal 

Here is how you can do it. Using muti-row formula tool.

Workflow:

Hope this helps : )

[AshishAgarwal]

Thank you so much for helping.

I am having huge amount of data and not necessary that IRS line will come below CCY line.

Also for some alphabet there is no IRS line also.

I wanted to search IRS first than for alphabet "A" with CCY will add "IRS Adjustment" to Daily P&L.

Hope I am clear now

[atcodedog05]

Hi @AshishAgarwal 

Try this i am only isolating CCY and IRS rows sorting them and calculating. This way order doesnt matter.

Hope this helps : )

[AshishAgarwal]

Thank you so much.

Small Amendment in working file is giving incorrect output.

If particular Alphabet is not having "IRS" & "CCY" line than above workflow will fail.

Attached working file.

I am trying to get solution for my problem.

[atcodedog05 · Accepted solution]

Hi @AshishAgarwal 

Please find the adjusted workflow.

Hope this helps : )