Hi guys, I'm wondering if I could get some advice on this problem I have. I want to compare two columns (from two different files, but copied into a new sheet) for duplicates or identical entries.
But here's the trick, each entry contains atleast a number of digits. I'm not quite sure how to find items that may be 80% identical (in the right order, but might be messing a digit, or there is a dash or a 'o' instead of a '0'). I know how to do it in C++ or Java, but not quite sure how to do it in VBA/macro.
Here's an example of what I meant
Let's say column one has the following:
and second column has
If I was comparing second column to first column, it can pick up the 9393-O0 one because it's close enough to 939300.
Hope to hear from someone soon, thanks!