Find any duplicates, and eliminate the data with lower level of priority.

Hi guys.

i got one problem .I would run this workbook on daily routine. So i hope it can be in form of VBA code so i can make it even simple to manage. I hope u guys can help me here.


I want to find duplicates Order in Column A. Only if it find any,then it will refer to column D. So here is the critical part. Based on column D value , the code will keep the entire row with high level of priority, and eliminate the rest of them.

So here is the level of priority in column D , sorted from highest to lowest.
1) QC-NDE
2) XTPAINT
3) QC

But if the level of priority in Column D is also same, then it will refer to OpAC in column B. The code will keep the entire row with LOWER value and eliminate the rest.


So at last, there will be only one kind of Order with the highest level of priority and lowest OpAC..See my attachment. You may consider you have solved the code when you can eliminate the rows with red highlight.


Thanks in advance .Really appreciate your help.

Do you care about the order of the data? Is it okay if it is sorted through the VBA code?

I have written the code and the sheet at the end gives the output of the code. Have not defined sheet name within the code so make sure you are on the main sheet and then run the code. Secondly, I have defined the range within the code starting row 11 so make sure that the format does not change.

Feel free to reach out in case you need anything further on it.

Hope the enclosed macro serves the purpose.

If you are happy with the solution, could you please mark this thread as solved and save the moderators some effort.

See if this works.

Didnt realize the solution was as simple and straight forward as the one provided by Jindon! Brilliant!

Thanks both of u nayway.. i will mark this as solved then.