delete based on criteria

Hi all-

I have a very large excel file with 2900 rows and 25 columns. I would like an if function or macro that will compare what is in column A with column B and delete the entire row if the criteria doesnt match. For Example : items in Column A that appear more than once (ex.MAR) but has conflicting statuses is to have the rows with the status of Pending to be deleted. If there is no conflicting rows for column A item I would like it to stay. I would like the whole entire row up to column Z to be deleted for each time the macro deletes. thanks for your help.


See attached for sample data.