I had posted this same question. I did not get a good answer. But now I
have simplified my own question. Hope this will help. I need a formula
that deletes entire row based on a criteria. For example
row 1 - contains what i need, so keep it
row 2 - contains a data that I would like to delete
row 3 - same as row 1, keep
row 4 - same as row 2, delete
What is common for the rows that I want to delete is they all start
with a number while the rows to keep start with letters. This is TRUE
up to row 151 and is reversed from row 152 up to row 347 i.e. I would
like to keep row 152 but delete row 153 etc
Please help




--
ab3d4u