How do I remove duplicate rows if there is a duplicate in column 1?

Jess A

My data has unique Job IDs but every time a row is updated in my master sheet it is moving it into another sheet creating duplicates. I want to delete the older rows and just keep the newly added row. How do I do this? Please help.

Jess A

@Michelle Choate 2

Any idea how to do this one?

Kelly Moore

Hey @Jess A

One way is to add a helper column to your master sheet that looks to see if the unique ID already exists on your other sheet. You can then set your automation to run only when the helper column indicates the ID is a new ID. (Do you want the Move Row to happen when all master sheet updates are completed?)

Create a helper checkbox column on your master sheet. As with most helper columns, you can sling this column to the far right and hide it if desired.

=IF(your unique ID master sheet]@row<>"", COUNTIFS({source sheet Unique ID column},[your unique ID master sheet]@row)=0,1)

Add a condition to your automation to only move rows when the box is checked.

Will this work for you?
Kelly