Forum Discussion
Highlight or Conditional Format SIMILAR matches within the same column
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.
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!
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.
KLoveall thanks for your response. In the meantime, I found https://www.mrexcel.com/board/threads/find-and-highlight-partial-matches-in-one-column.1096257/ with a formular that came closest but not quite to what I was looking for. It helped me some but I'll look into your suggestion on "Ablebits" as well.
