Forum Discussion

Copper Contributor

Jun 25, 2021

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 wi...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jun 25, 2021

KLoveall

Perhaps this Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center could help, but I had no practical experience with.

KLoveall
Copper Contributor
Jun 28, 2021
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.
- SteveMM
  Copper Contributor
  Oct 11, 2022
  KLoveall did ypu ever get a solution to this? I have the same problem you described and fuzzy lookuup isn't helping me. Please let me know if you managed to resolve this for finding 'similar-but-not-exact' matches within the same column. Thanks!
  - KLoveall
    Copper Contributor
    Oct 14, 2022
    SteveMM No, I ended up installing a 3rd party add-in called "Ablebits" - you can google them to find them. They have some really cool fuzzy lookup tools, but nothing that I know of yet built into MS unfortunately.