improve the following function so it compares columns A:K of the row, and when it is duplicate, it removes the whole row function removerDuplicatas() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; var lastRow = sheet.getLastRow(); var range = sheet.getRange(1, 1, lastRow - 2, 15); range.removeDuplicates(); organizarDados(); }

function organizarDados() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var range = sheet.getRange(2, 2, sheet.getLastRow() - 2, 15);
  var sort = range.sort({
    column: 2,
    ascending: true
  });
  sort.sort({
    column: 4,
    ascending: true
  });
}