Remove One Row for a given project

Hi Guys,

I need your help with the below issue I am facing currently, as you can see there are two columns and I want to check “if a given project contains AA-Project Manager, if it contains then remove AAA-Project Manager row” from the given project. When a project either AA-Project Manager or AAA-Project Manger is fine like last two projects but if one project contains both types of Project Manager then need to remove the ‘AAA’ row from that project. Does anyone has any idea how to get this done as this is a little bit urgent. I have attached

Projectsss.xlsx

the data file as well.

Thanks in advance,