Excel_Novice_
New Member
- Joined
- Jun 19, 2018
- Messages
- 2
Any help would be appreciated, I have a workbook where I need to find fuzzy duplicates, however I am not sure how to code in VBA. I was looking to get it put a percentage and row number of the duplicate in the two columns next the data to indicate a duplicate/ possible duplicate. like this:
<tbody>
</tbody>
Percent Match | Row Match | Name |
100% | 7 | Nike |
90% | 6 | 3M |
99% | 5 | Adidas |
99% | 4 | adidas |
90% | 6 | Three M |
100% | 2 | Nike |
<tbody>
</tbody>