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

Please find the adjusted workflow.

Hope this helps : )

All comments

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

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.

Book2.xlsx

Please find the adjusted workflow.

Hope this helps : )