Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank

by

I can suggest a simple solution without using a script !!

Lets say you want to delete rows with empty text in column C.
Sort the data (Data Menu -> Sort sheet by column C, A->Z) in the sheet w.r.t column C, so all your empty text rows will be available together.

Just select those rows all together and right-click -> delete rows.
Then you can re-sort your data according to the column you need.
Done.

More Related Contents:

  1. Determining the last row in a single column
  2. Moving google apps script to v8 file upload stopped working from sidebar
  3. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  4. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  5. Google Sheets OnEdit() – You do not have permission to call a service
  6. Detect user inserting row or column in a google spreadsheet and reacting in a script
  7. How to define global variable in Google Apps Script
  8. Periodically refresh IMPORTXML() spreadsheet function
  9. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  10. Format a Google Sheets cell in plaintext via Apps Script
  11. Selecting the last value of a column
  12. Moving Files In Google Drive Using Google Script
  13. Google apps script to email google spreadsheet excel version [duplicate]
  14. onEdit simple trigger never seems to be triggered
  15. How to get filtered values from Filter after using setColumnFilterCriteria?
  16. Protect ranges with google apps script
  17. GAS “On edit” trigger not running when edited from API
  18. How to access new ‘in-cell-image’ from google apps script?
  19. How to convert a Google Sheets-File to an Excel-File (XLSX)
  20. Difference between getValue() and getDisplayValue() on google app script
  21. How to allow onEdit function to affect protected cell in a Google Sheet?
  22. Creating and Sending sheets in the same function
  23. How do I know if spreadsheet cells are merged using google apps script
  24. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  25. Custom Functions with add-ons?
  26. Google apps script error: “You do not have permission to call protect” [duplicate]
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. .setFormula() and received error missing ) argument list
  29. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  30. Passing cell references to spreadsheet functions

Leave a Comment