How do you delete rows in spreadsheet where condition met and location of condition unknown
I need to find the word Overdue" and Due in a spreadsheet  but the column they appear in will be variable as will the number of records (rows). i need to delete all rows that do NOT have these values in the data - then total up the data left on the sheet after the others have been deleted - any clues?
How do you delete rows in spreadsheet where condition met and location of condition unknown
===

I need to find the word Overdue" and Due in a spreadsheet  but the column they appear in will be variable as will the number of records (rows). i need to delete all rows that do NOT have these values in the data - then total up the data left on the sheet after the others have been deleted - any clues?