VBA countifs super slow

Hi

I have a long list of order lines which will vary in size from 1000 to 50000+ rows.

Something like this:


Order No: Item Start Time
3000 Phone 30/06/2016 12:12
3000 Memory Card
3000 Cover
3001 Phone
3001 Memory Card
3002 Phone 30/06/2016 11:26
3002 Memory Card
3002 Cover

I need to filter so I see all order lines for the orders that have a start time.

So after my filter I would need to see this:

Order No: Item Start Time
3000 Phone 30/06/2016 12:12
3000 Memory Card
3000 Cover
3002 Phone 30/06/2016 11:26
3002 Memory Card
3002 Cover


My order number is in column E, and my other criteria is in column AA

My idea (which I got from this forum ) was to add a column (AK) with a countifs formula, and since I'm moving some data around later I wanted to copy/paste values.

My code works, but it is very, very slow.

Please Login or Register  to view this content.

Later in the code I do the actual filtering based on my countifs results, but that part works fine.

Is there a faster way to handle the countifs?

Or is there a different way to filter this?

Try:

Please Login or Register  to view this content.

Please note how use of code tags improved readability above, and take action:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this request is fulfilled, as per Forum Rule 7)