Duplication remove with criteria

Hello follow forumers!!!

I need some help!! I am probably overthinking this and that is why I can't figure our how to either create the necessary formula or VBA coding to achieve my desired output, but think VBA is probably going to give me the final output I really want. So here is the deal...I have a data set that contains duplicate records. I could have an asset that has 2 or more records of data within this data set. It could be an OEM repair or an In House repair. I want to search row by row through each duplicate and if the oldest record has a repair type of In House repair, then delete that record and move on to the next record in the data set.

I have attached the data set I am working with...any ideas would be extremely helpful!!!!

That does not appear to be calculating all of the data criteria correctly. I am still seeing records that should be marked as "Delete" but are blank. Something is off and I can't figure out what or how to fix it.