Highlight or Conditional Format SIMILAR matches within the same column

New Contributor

I am trying to find a way to highlight SIMILAR matches to values within one column. I have found some helpful tips on comparing TWO datasets with similar matches found, but not anything that looks within it's own column to find a similar match. We have customers from a lead source that may have duplicate listings with similar, but not exact name matches, i.e.


"Test ABC"

"Test ABC, Inc"

"Test ABC Inc"


Is there any formula that can see these similarities within the same column, and highlight them?

2 Replies

@Sergei Baklan  Thanks! I did look into that and tried to see if that would work for this project - it is great for comparing two datasets, but that is where I am stuck. I have one dataset that I want to somehow find duplicates within.