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.