generate functionTue, 17 Jan 2023

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(); }

Javascript
Generate More

Questions about programming?Chat with your personal AI assistant