Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function removeDuplicates() {
- var dedupeSheet = SpreadsheetApp.getActive().getSheetByName('Combined');
- var data = dedupeSheet.getDataRange().getValues();
- var newData = [];
- for (var i in data) {
- var row = data[i];
- var duplicate = false;
- for (var j in newData) {
- if(row[0].toLowerCase() == newData[j][0].toLowerCase() || (row[0].split(" ").length < 3)){
- duplicate = true;
- }
- }
- if (!duplicate) {
- newData.push(row);
- }
- }
- dedupeSheet.clearContents();
- dedupeSheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement