let's try it one more time

  • Thread starter Thread starter ab3d4u
  • Start date Start date
A

ab3d4u

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
 
Sorry, but there is no formula that will delete a row. Here's a suggestion,
though.

First, add a helper column next to your data. Fill it with your row
numbers. Sort the first section of data along with the helper column.
Delete the rows that start with alpha characters. Then, sort the second half
of the data along with the helper column and delete the rows that start with
numbers. Last, resort all the remaining data using the helper column. This
will put it all back in the original order.

HTH
Jim
 
Back
Top