If Condition

[Jaganmohan]

Hi Team,

Need help on below please :

Need to Create a comment column by using below logic.

Out of all transactions :
Same identifier with same fund having Description sell/resell with same amount of shares (sell -1280 and resell 1280 quantity of shares)  ... for those identifiers need to mentioned comment as "Trade reversal" and for others comment it as "NO" - Thanks In advance.

ex: same identifier 89  same fund as 123 with sell and resell description and same quantity of shares -1280 and 1280.

Output :

Identifier	Description	fund	shares	Comment
89	sell	123	-1280	Trade Reversal
89	Resell	123	1280	Trade Reversal
94	sell	789	-4500	Trade Reversal
98	sell	666	9000	No
94	resell	789	4500	Trade Reversal
56	sell	888	-2300	No
56	resell	888	2200	No

[ShankerV · Accepted solution]

@Jaganmohan 

Please find the expected output

[Felipe_Ribeir0]

Hi @Jaganmohan 

One way of doing this