Bulk operation to tag duplicate addresses in database

Need help Database
1

Hello - I am trying to perform a bulk operation on my database to tag duplicates based on a field called “text address”. I set the field to change when the count of that field exceeds 1. Instead of just marking the duplicates, it is marking all entries! What am I missing?

06%20PM
Screen Shot 2019-03-04 at 1.15.06 PM.png595×661 32 KB

23%20PM
Screen Shot 2019-03-04 at 1.15.23 PM.png800×539 30.4 KB

27%20PM
Screen Shot 2019-03-04 at 1.19.27 PM.png1118×735 50.8 KB

2

Update: So I made some progress and now am able to mark all duplicates however I ideally want to mark all but 1 of the duplicates. Any idea on how to exclude 1 value from being marked?

Here’s where I’m currently at:

09%20PM
Screen Shot 2019-03-04 at 6.32.09 PM.png1741×452 47.9 KB

1 Like