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 |