How do I remove duplicate rows if there is a duplicate in column 1?
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.
Answers
-
Any idea how to do this one?
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!