Guest User

Untitled

a guest
Apr 22nd, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. function removeDuplicates() {
  2. var sheet = SpreadsheetApp.getActiveSheet();
  3. var rows = sheet.getLastRow();
  4. var firstColumn = sheet.getRange(2, 2, rows, 1).getValues();
  5. for (var i = rows; i >= 2; i--) {
  6. if (firstColumn[i-1][0] == firstColumn[i-2][0]) {
  7. sheet.deleteRow(i);
  8. }
  9. }
  10. }
  11.  
  12. var firstColumn = sheet.getRange(2, 2, rows, 1).getValues();
  13. for (var i = rows; i >= 2; i--) {
  14. if (firstColumn[i-1][0] == firstColumn[i-2][0]) {
  15. sheet.deleteRow(i);
  16.  
  17. var firstColumn = sheet.getRange(1, 2, rows, 1).getValues();
  18. firstColumn = firstColumn.map(function (e) {return e[0]})
  19. for (var i = rows; i >0; i--) {
  20. if (firstColumn.indexOf(firstColumn[i-1]) != i-1) {
  21. sheet.deleteRow(i);
Add Comment
Please, Sign In to add comment