Forum Discussion
Duplicate Values that are not exact match
Hello, I have an excel file with names I need to clean up. I started with using conditional formatting to highlight all duplicate values and deleted the duplicates. There are still duplicates in ...
You may try this Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center tool
- Thank you. I'll give that shot.
As variant you may try Fuzzy join in Power Query which could give something like
but that takes time to play with parameters.
Any Fuzzy tool won't give absolutely correct result, it's with some probability. We may improve result with options, but in any cased it shall be reviewed finally.
