Script to delete duplicate rows based on cell value in a column

Question

I am fairly new to scripts.

I found the following script and would like it to be able to search in Column W for any duplicates and when it finds any to then delete the duplicated rows

function removeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getLastRow();
  var firstColumn = sheet.getRange(2, 2, rows, 1).getValues();
  for (var i = rows; i >= 2; i--) {
    if (firstColumn[i-1][0] == firstColumn[i-2][0]) {
      sheet.deleteRow(i);
    }
  }
}

halfer · Accepted Answer · 2019-10-02 21:35:58Z

1

Try changing the following line:

var firstColumn = sheet.getRange("W:W").getValues();

edited Oct 2, 2019 at 21:35

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Feb 22, 2019 at 22:50

J. G.

1,8302 gold badges16 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Script to delete duplicate rows based on cell value in a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related