Access Partially match 2 lists


Joined
Apr 17, 2018
Messages
1
Reaction score
1
Hello,
I'm trying to partially match 2 lists.
I have about 13000 lines in each one and I would like to match like 80% of the name for each one with what it can find in the other list. For example if there is "444 MGX" in one list and in the other I have "444 MGX company" I'd like to flag this.
Can something like this be done without entering all the criteria by hand? Is there a criteria similar to Like " " where I enter about 80% similarity or something?
 
Ad

Advertisements

Joined
Mar 14, 2018
Messages
617
Reaction score
200

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top