2800_en-US

liliconcom

Deleting Rows based on criteria from multiple columnsI 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.Re: Deleting Rows based on criteria from multiple columnsThanks for the help gentlemen, I found both methods to work and be very useful!Re: Deleting Rows based on criteria from multiple columnsThere are a couple of pretty efficient ways to do this interactively if you're not looking for a scripted solution.

Try the Select Where... option under the Rows:Row Selection menu. You can select rows based on multiple conditions, including greater than and less than comparisons.

The Data Filter also works well to select rows based on multiple conditions.

Once the rows are selected just delete them.

JeffRe: Deleting Rows based on criteria from multiple columnsYou need a small script like the following: