Deleting Rows based on criteria from multiple columns
Jan 5, 2011 8:34 AM(1385 views)
I have a table that is test data from multiple test subjects. Due to system issues, occasional rows are "bad", affecting all test subjects. The columns hold data for each test subject. I would like to delete these bad rows based on criteria from all columns. Criteria is that if every column has a value below x, that row is deleted. Seems that I need to use "For Each Row" in combination with If() and And() but scripting guide does not have any helpful examples using And(). Any tips?
I could do this manually except I have over a million rows.