Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. function removeDuplicates() {
  2. const startTime = new Date();
  3. const newData = [];
  4. const sheet = SpreadsheetApp.getActiveSheet();
  5. const data = sheet.getDataRange().getValues();
  6. const numRows = data.length;
  7. const seen = {};
  8.  
  9. for (var i = 0, row, key; i < numRows && (row = data[i]); i++) {
  10. key = JSON.stringify(row);
  11. if (key in seen) {
  12. continue;
  13. }
  14. seen[key] = true;
  15. newData.push(row);
  16. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement