Hi,

@JapanDave, or others.

I have a set of data and I would like to filter out and delete rows that I do not require based on multiple conditions.

The way I have approached this is to create a column in my data and return "keep" or "delete" based on the criteria I specify, and then use AutoFilter and SpecialCells(xlCellTypeVisible).EntireRow.Delete to delete all cells flagged as "delete".

The conditions I would like to satisfy I can easily write as a Excel formula, But I am new to VBA and would like to implement them to loop through my data and then automatically delete.

Problems also arise that the 'blank' cells in my data set also contain spaces that makes it harder to provide an Iftext or Ifnumber function.

Example Workbook 130628 3.xlsx

Please see the attached spreadsheet. I'd like to populate Column E for all lines of my data for the following contitions:

Corresponding row in Column D = Text
or,
Corresponding row in Column G = Text
or,
Corresponding row in Column Q = Numeric Value.

If someone could help me with the code to return "keep" or "delete" based on the above, I can implement this into my delete coding to remove the unwanted lines.