Offsetting Logic

[ashriva2]

I need to apply the filter as "if the Value (i.e. col. "A") is same and "identity" and "reversal of identity - Prefix with alphabet "R" (i.e. col. "B") with same amount but in opposite direction (Col. "C") then that line item should have comment as "offsetting tran"

Eg. Security 123abc456 is having IND - and Reversal as RIND - with same amount in opposite direction I,e, 80.02 and -80.02 should have comment as "offsetting tran"

Attaching excel file with data

[cjaneczko]

Does this do what you are looking for?

Use a multirow Formula.

if ([Row-1:Amount]) = ([Amount]*-1) then 'Offsetting Tran' else '' endif

[ashriva2]

Thanks, but I need to re-phrase my problem: Challenge here is these "identity" does not always in a sequential order, I am attaching new excel with new data.

[cjaneczko · Accepted solution]

Add a sort tool before the formula tool to put it in the proper order.