row comparison

[Rive11115]

I want to add New_Column "Notes_1" with related or potential dup:

Related:

are lines where the sum of the amounts in column amount1 is 0.

CC are the same

Value 3 the same

See row 1 & row 16

Potential dup:

Amount_1 are the same

Cc are the same

Value 3 are the same

See row 4 & 15 

[aatalai]

take a look at the multi row tool that might be the best starting point, strugglying to follow what your ask is. Also use the unique tool if you want to find duplicates

[Rive11115]

When I sort the list on value3. CC and amount, I can get row 1 above row 16, using row-1 I can get row 1 to be marked by the comment, but I’m struggling to get the active row, row 16, marked as well.