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

  • Kerry St. Thomas
    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!

    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.