I have a list with two columns of potential home owner names, one is the "registered agent" and one is the "authorized representative" from LLC data. In some cases the registered agent column has duplicates, but only some of the duplicates have both a registered agent and an authorized representative listed. I want to remove any duplicates I have in the registered agent column, but I want to make sure the single duplicate that remains afterward is always the one that also has the authorized representative so I don't lose that secondary owner information.
Is there anyway to make this happen with a formula? I added a screenshot for reference.
Screen Shot 2022-04-11 at 10.54.01 AM.png
Bookmarks