Forum Discussion
Highlight or Conditional Format SIMILAR matches within the same column
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?
6 Replies
- If you have access to LAMBDA, one approach might be using SCAN. You'd string-out the lookup value to make it an array then SCAN it. Feed the results to XMATCH but only accept hits if the element from the array is 90% as long as the total length (This can be adjusted). I may post a sample later, time permitting.
Perhaps this Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center could help, but I had no practical experience with.
SergeiBaklan 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.
