Hi everyone,

I need to delete duplicate rows in a sheet.

How can I create an automation to delete one of the "n" duplicate rows?

How can I create an automation that deletes a row completely under specific conditions?

Also, is it possible to highlight duplicate rows with conditional formatting?

Thank you!


  • Scott Orsey
    Scott Orsey ✭✭✭✭✭

    Hi, I believe this question has been answered in other threads in the Community so you may want to do a little search.

    The basic process would be the following:

    1) Create a column with a formula that identifies the duplicate rows. For one approach, see my answer to this question:

    2) Use an automation to MOVE the duplicate based on the value that you determined in 1). You cannot delete rows. You can only move them to another sheet. Consider creating a "trash" sheet for this purpose.

    3) You can also use conditional formatting to highlight the duplicate rows.

    Hope this helps.

    Be well

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!