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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives