Identify duplicates with multiple criteria in another column

[Robot1]

I have been searching the boards for hours. I am looking to identify duplicate accounts based on the text in a different column. I can't just sort and remove duplicates as it will delete "active" accounts. Some accounts are active in multiple rows. I had to create a sample sheet as the data is sensitive and could not be shared. From the example below, I need to identify that Scotia Bank has both "Account" and "Firm" and then delete the "Firm" but keep both the account lines.

Account	Scotia Bank
Account	Scotia Bank
Firm	Scotia Bank
Firm	Scotia Bank
Firm	Scotia Bank
Account	Jim's Bakery
Firm	Jim's Bakery
Firm	Jim's Bakery
Account	Publix
Account	Publix
Account	Publix
Firm	Publix
Firm	Publix
Account	Costco
Account	Fedex

 

[sprigelz]

You could add a third column that concat's the other 2 and then filter the third column to delete the duplicates.

=CONCATENATE(A1,"-",B1)

 

[Robot1]

Thank you. That might actually work. I will try on the main sheet and report back.