Hiding all rows with inexact matches

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?

Can you post the sample file?

Not sure what you mean - can you elaborate?

Originally Posted by Fair2Midland

Not sure what you mean - can you elaborate?

Can you attach a sample file so that we can see have a bigger dataset to work with.

But also

Originally Posted by Fair2Midland

cell G7 is '2457 Industrial Park Rd' while cell L7 is "Industrial Park Rd." Still equals 'false' though.

Yes, that is returning false because one has a period symbol of Rd. and one does not not.. ie Rd

Sorry - that was a typo. Neither have periods. I've attached a sample.

See if this works.

The original formula I posted is returning TRUE with that Industrial Rd comparison, but try this as well.

This uses a VBA match function created by Excel MVP Rick Rothstein

Please Login or Register  to view this content.

Plugged this into the VBA editor and ran it - no dice. Do I need to edit anything after pasting?