Loop to Delete Entire.Rows if conditions are met

Hi

I am looking for a way to delete Entire.Rows in excel if certain conditions are met. I have tried writting code but seeing as I am moderate this one is a little too advanced for me, a sample spreadsheet is attached for your reference.

The conditions is:
If any particuliar Row has the same Price (column M) & same Billing Account (Column J) & same Contract (column AA) as another row [/I] THEN simply delete the Entire Row where there is text found in Column AC

It may sound complicated, but with the sample spreadsheet it is easy to follow. Basically I am trying to delete the dup that occurs, I am dealing with thousands of rows of data so can't manually do this.

To sum up:
If a Particular Client has a case where the Account & Price & Contract are the same, I need one of the lines deleted, the line that would be deleted is the one with text found in AC. I originally had a macro to delete all rows with text in AC, but it was deleting stuff that wasn't dups, this is why I need to encorprate these conditions.

In my sample spreadsheet I highlighted in blue where this situation would happen, and if I were to run a macro it should only delete 2 lines, one from each case. ** in real spreadsheet rows where this dups appears may not neccesarily be adjacent to each other

This is a little too advanced for me, I will take whatever help I get and learn off you for next time. Greatly appreciate anyone helping me out.

Have a bless day.

Hi and welcome to the forum,

Here's a suggestion. The code is simple, you should be able to understand it.
The idea is to store the "unique" values in a dictionary

Please Login or Register  to view this content.

Will the duplicates always be in adjacent rows as you have in your example?

Note :
the code will work as long as the row to keep (without the text in AC) always appear first.
If that's not the case, the code will have to be modified.

@ GC Excel

Hello GC Excel,

I like your Dictionary deploy. May we add in Columns.Autofit?

Please Login or Register  to view this content.

Cheers.

Hi,

no worries, there's always a solution in Excel.
Logic of the code is slightly changed... see below.

Please Login or Register  to view this content.

Here's a block deletion adaptation of GC's code:

Please Login or Register  to view this content.

Here's a speed improvement adaptation of xladept's adaptation of GC's code.

The Input data is read en masse into an array (for speed) and then the array is processed.
Also, a logic change to delete the duplicate with the sting if it occurs first or second.

Please Login or Register  to view this content.

Please Login or Register  to view this content.