Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Deleting Rows Based on Cell Values
- //GLOBALS
- var SS = SpreadsheetApp.openById("1MGh6Mrod7T21ORrmaTOTWvjgi_6XhPv-ecUyL_MdoxE");
- var SHEET = SS.getSheetByName("cache");
- var RANGE = SHEET.getDataRange();
- var DELETE_VAL = "NO";
- var COL_TO_SEARCH = 11; //Zero is first
- function main() {
- var startTime = new Date().getTime();
- var deleteSelectedRows = removeThenSetNewVals();
- var runTime = (new Date().getTime() - startTime)/1000;
- Logger.log("Runtime is: "+runTime + " seconds");
- };
- function removeNonMembers(){
- var rangeVals = RANGE.getValues();
- var newRangeVals = [];
- for(var i = 0; i < rangeVals.length; i++){
- if(rangeVals[i][COL_TO_SEARCH] != DELETE_VAL){
- newRangeVals.push(rangeVals[i]);
- };
- };
- RANGE.clearContent();
- var newRange = SHEET.getRange(1,1,newRangeVals.length, newRangeVals[0].length);
- newRange.setValues(newRangeVals);
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement