So I'm trying to identify inexact matches among data and hide those rows. The data looks something like this -
Column a: Mailing address of property owner
Column b: Physical address of property.
I want to hide the rows referencing property owners that also live on the property. However, the data appears usually appears similar to like this:
Column A (mailing address): 12445 Troth Lane, Statesville
Coumn B (property address): Troth Lane
This would be an example of a property owner that lives on the actual property - I need to delete/hide these.
But because the match isn't an exact duplicate, I'd just have to search for "troth" or something like that to identify and hide the correct rows. Any idea how to do this?
Bookmarks