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(); }
function removerDuplicatas() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; var lastRow = sheet.getLastRow(); var range = sheet.getRange(1, 1, lastRow - 2, 15); range.removeDuplicates(); }