Forum Discussion

Copper Contributor

Jan 16, 2024

Finding possible duplication

Hi, I have a set of data (vendor & customer name). There seems to be a duplication but most of the duplication are not exact. Example are as below: - Johnson Charles and Johnson Charhles - AB...

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

Rodrigo_

Steel Contributor

Jan 16, 2024

Syed_001

Ever heard Fuzzy Lookup? It's an add-in that is similar to lookup function but you can use it to lookup for a data which is not exactly the same as your lookup value.
you can refer here> How to use the Fuzzy Lookup add-in in Microsoft Excel - YouTube