Identifying and Archiving Duplicate Rows While Retaining the Oldest Entry
I require help in detecting duplicate rows and transferring them to an archive sheet while retaining the oldest entry. Your assistance is highly valued. Thank you!
Answers
-
Assuming your column ID is an autonumber column here. You can use a formula in your duplicate checkbox column to see if an individual row is the smallest ID for that Ticket number.
=IF(MIN(COLLECT(ID:ID, Ticket:Ticket, Ticket@row)) = ID@row, 0, 1)
This will check the box for ONLY duplicates.
Separately, you can set up a Move Row automation with "When a date is reached" as trigger (and set up as a reasonable cadence for your use case), with "Duplicate Is Checked" as a condition.
—
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" buttons are much appreciated. Thanks!If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks Kerry. Yes the column ID is an autonumber column.
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