Identifying and Archiving Duplicate Rows While Retaining the Oldest Entry

Adedeji Adebanjo

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!

Kerry St. Thomas

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!

Adedeji Adebanjo

Thanks Kerry. Yes the column ID is an autonumber column.