Google Apps Script - Remove duplicates in all sheets with one function

Question

I have this code from another question that works perfectly for me, but I'd like to get it to remove the duplicates of every sheet and not just the currently active one. This is also for large spreadsheets with a lot of data, so I have to keep the 6min execution time maximum in mind as well. Does anyone have any ideas?

Here's my code:

function removeDuplicates() {
  SpreadsheetApp.getActiveSheet().getDataRange().removeDuplicates();
}

Tanaike · Accepted Answer · 2021-04-22 06:42:16Z

2

How about the following modification?

From:

SpreadsheetApp.getActiveSheet().getDataRange().removeDuplicates();

To:

SpreadsheetApp.getActiveSpreadsheet().getSheets().forEach(sheet => sheet.getDataRange().removeDuplicates());

In this modification, all sheets are retrieved with getSheets() and the duplicated rows of each sheet is removed with removeDuplicates() in a loop.

References:

answered Apr 22, 2021 at 6:42

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Michael Hawk Over a year ago

Perfect. Thank you very much!

Tanaike Over a year ago

@Michael Hawk Thank you for replying and testing it. I'm glad your issue was resolved. Thank you, too.

Collectives™ on Stack Overflow

Google Apps Script - Remove duplicates in all sheets with one function

1 Answer 1

From:

To:

References:

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

From:

To:

References:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related