row comparison

Question

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

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

Book1.xlsx

Rive11115 · Answer

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.

aatalai · Answer

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