Automation

malanto

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

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:

How to check the Duplicate rows except the first occurance

usha236

Mar 14, 2024

Hi. I have been tring to implement this with a column formula. I was able to check all the occurances but I want to ignore the first occurance.

I used the following formula

=IF(COUNTIFS([Conference Room]:[Conference Room], [Conference Room]@row, [From:]:[From:], [From:]@row, [To:]:[To:], [To:]@row, [Time:]:[Time:], [Time:]@row) > 1, 1, 0)

can someone please let me know on how I can modify this formula such that I can get my desired output.

Thank you

---

View Post

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