Macro to delete rows based on multiple criteria

Hi

A macro is required to identify rows within a selection e.g. entire column A, that share the same value, then delete appropriate rows depending on the values in another column. The attached example details the requirements.

If anybody can help that would be great.

Extract Rec1.xlsx

Thanks