Delete Entire rows without loop with multiple partial strings criteria

**caabdul** · 03-03-2018, 01:53 PM

I have a selection of cells

From this selection I want to delete all rows that DO NOT [edited] have "String1" or "String2" as part of that cell.

I have done it with loop but that takes much time. Is it possible to do this without loop?

Note: Selection is from a single column.

**YasserKhalil** · 03-03-2018, 01:58 PM

You can use reverse loop from the last row in the selection and then to store the cells that match the criteria in a range variable and at the end to delete the whole stored range ..

**shg** · 03-03-2018, 02:15 PM

I would filter for "Contains" String 1, clear those rows, filter for "Contains" String 2, clear those rows, and then sort on an appropriate columns to close up blanks.

**caabdul** · 03-03-2018, 02:38 PM

Sorry, I misstated. I wanted to remove rows that DID NOT meet the criteria.

**daboho** · 03-03-2018, 03:55 PM

or you can do using replace ,manipule data example in columns(1) you have formula than you can replace string1 become error

Please Login or Register  to view this content.

**caabdul** · 03-03-2018, 04:15 PM

Hi daboho

Thanks but I want to keep the rows that contain any of these two strings and remove the other rows.

**daboho** · 03-03-2018, 04:26 PM

Please Login or Register  to view this content.

or not 2 string

Please Login or Register  to view this content.

**caabdul** · 03-03-2018, 07:30 PM

Hi daboho

I tried but it deletes all the rows

**jeffreybrown** · 03-03-2018, 07:32 PM

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 then scroll down to Manage Attachments to open the upload window.

**bakerman2** · 03-03-2018, 08:29 PM

This should do it.

Please Login or Register  to view this content.

**daboho** · 03-04-2018, 01:49 AM

if you want delete all rows except "string1" and "string2"

Please Login or Register  to view this content.

**bakerman2** · 03-04-2018, 12:05 PM

Suddenly marked as solved ?

Delete Entire rows without loop with multiple partial strings criteria

LinkBack

Thread Tools

Rate This Thread

Display

Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Re: Delete Entire rows without loop with multiple partial strings criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] loop multiple criteria & delete matching rows?

Using loop(s) to delete rows based on criteria

[SOLVED] delete entire row if multiple criteria are satisfied

Loop through rows and delete based on criteria

Delete rows NOT containing 1 of multiple strings in a column

Loop to delete rows meeting criteria

delete entire rows based on a criteria

Bookmarks

Bookmarks

Posting Permissions