Establishing duplicate entries, highlighting them, then deleting

Hi

I have a spreadsheet with thousands rows of items on. I am trying to identify duplicate entries based on two or three cells within each row. If those two or three cells are duplicated for that particular ID then the duplicate entry (row) should be highlighted for deletion.

Better still it would be great if there was a macro or formula which would delete that duplicate row.

So for example on the spreadsheet I have attached, I would like rows 6 and 9 deleted or highlighted as the criteria for deletion is a duplication of the entry in the 'YEAR' column AND the 'VALUE' column for the REFERENCEs AB-1234 and AB-9876 which are the unique identifiers for each individual case.

This would leave the end result as per the table below on the attached spreadsheet.

I would very much appreciate any help on this.

Thank you in advance.

Sktneer and oeldere. That is brilliant. Just what I wanted.

Thank you so much.