Skip to content

Instantly share code, notes, and snippets.

@vicdecode

vicdecode/find-cell-value-and-delete-row.js

Forked from dDondero/find-cell-value-and-delete-row.js
Created February 25, 2021 21:35
Show Gist options
  • Save vicdecode/7cb3f33c57e8935d0c8119a0dfdb0cf2 to your computer and use it in GitHub Desktop.
Save vicdecode/7cb3f33c57e8935d0c8119a0dfdb0cf2 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @dDondero dDondero created this gist Dec 8, 2015.
    15 changes: 15 additions & 0 deletions find-cell-value-and-delete-row.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    function deleteRows() {
    var sheet = SpreadsheetApp.getActiveSheet();
    var rows = sheet.getDataRange();
    var numRows = rows.getNumRows();
    var values = rows.getValues();

    var rowsDeleted = 0;
    for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[0] == 'delete' || row[0] == '') { // This searches all cells in columns A (change to row[1] for columns B and so on) and deletes row if cell is empty or has value 'delete'.
    sheet.deleteRow((parseInt(i)+1) - rowsDeleted);
    rowsDeleted++;
    }
    }
    };