Delete all rows in which column does not contain specific word

[BVT3030]

How can I delete any row in which column H does not contain the word "example"? The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Trebor76]

Hi BVT3030,

Try this while on the sheet in question - though initially on a copy of your data as the results cannot be undone if they're not as expected:

Please Login or Register  to view this content.

Regards,

Robert

[jindon]

The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.

Perhaps

Please Login or Register  to view this content.

[Pan314]

How can I delete any row in which column H does not contain the word "example"? The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.

Hi BVT3030!

I tested. Pretty fast. Try it!

Sincerely Pan 314



1. If I helped, Don't forget to add to my reputation (click on the ★ AddReputation at bottom of this post)
2 If you see that the thread is finished, no more request: --->Don't forget to mark thread as "Solved"! (Edit First post>Advanced>Change Prefix

[jindon]

BVT3030

Thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[BVT3030]

All seemed to work but I went with jindon's since it was the most straight forward. Thanks all!