Want to update text for same duplicate data

[Srawat]

Hi,

First table has BBB and CCC duplicate in column E and on basis of that can we fill "Yes" in above row as mentioned the result table in blue color also want to make sure column B should one - and one + amount and getting zero of total. 

Thanks,

[grazitti_sapna · Accepted solution]

@Srawat , You can get your solution by using Row Field Formula. Please find the solution attached and accept it if this is what you were looking for.

Thanks!!

[binuacs · Accepted solution]

@Srawat Another way of doing this

[stefaniadurdan · Accepted solution]

Hello.

I am taking into account multiple variables from your exercise - such as:

1. what if the two BBBs are not one row after the one, but somewhere in the database

2. The - and + in the column B, I suppose this is not the input, but this is what you wanted to have in your output.

If my understanding is correct for the above, my solution is the below one (more complex than the others proposed, but I have taken in mind multiple scenarios :) )

Please accept my proposal as your solution if you consider it right.