Need better and more efficient code deleting unwanted rows.

[EXLent]

I have a table with apr 400K lines:
Column C for Ranking: R1 R2 R3 etc
Column D for Emails: lastname.firstname@mail.com

I read it is best to use filter then loop but it is not working for me.
I am trying to keep All R1 with the exception to Emails that has a period.
Looks like ones not needed is working and get deleted but then reappear.
What am I missing?

Please Login or Register  to view this content.

[Richard Buttrey]

You are quite correct, you certainly don't want to use a loop. Autofilter is the way.

Please upload the workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.


To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[Marc L]

Hi,

as the classic Sort & Clear method - see this thread - could be faster than the Filter & Delete method,
in particular with the more non contiguous rows to delete …

[EXLent]

With this example. Only line 3 should remains because C contain R1 and D contain a period.
Line 8 should not be use because a period is not present.

[EXLent]

I like that short and simple.
Clear and sort rather then delete.
I will try it out.

Hi,

as the classic Sort & Clear method - see this thread - could be faster than the Filter & Delete method,
in particular with the more non contiguous rows to delete …

[EXLent]

Though it is short and look simple. I tried to understand the code but not enough to modify or test to make it work for me

Hi,

as the classic Sort & Clear method - see this thread - could be faster than the Filter & Delete method,
in particular with the more non contiguous rows to delete …

[Marc L]

So attach at least a workbook in order some helper can give it a try : just follow the top page yellow banner …