How to delete duplicate records using criteria for multiple rows

Hi Guys,

I have attached a spreadsheet with my three problems. The dataset is a plot of trees being measured over successive years.
I want to find duplicate measurements and transparencies in the data between years. Once identified I want to be able to automatically delete / change them through script.

The following problems can be seen in the provided excel file.
Excel Validation Problems.xlsx

Any advice on this issue would be great.

Kind regards,
Ardiko