mikeleung110
New Member
- Joined
- Nov 5, 2015
- Messages
- 13
Extreme Complicated Name Matching (Using Function/VBA) REVISED
OLD POST:http://www.mrexcel.com/forum/excel-...on-visual-basic-applications.html#post4462510
Dear all,
I encounter difficult problem that is related to matching some customer names.
I have 2 Col, Col B(Name1) is raw data Col;Col F(Non-Sorted Name) is another name Col with difficult naming pattern which is not exactly matches.
Given: Col B (Raw data Col) , Col F (i.e. non-sorted names Col)
Task: Return the names of Col C (Name2) , i.e. Given Blue, I want to return Red!!!!!
You can see the image and the image can explain all the problems!!!
Actually it is just like a kind of "GOOGLE SEARCH" and searching names that matches with the most of the characters in the greatest amount of extent.
Actually, I think this nightmare problems just like "GOOGLE SEARCH"
That means finding a string and then highlighting the true hit parts / return the greatest extent of matches answers if possible.
ANOTHER LINK:
TABLE:
<tbody>
</tbody>
OLD POST:http://www.mrexcel.com/forum/excel-...on-visual-basic-applications.html#post4462510
Dear all,
I encounter difficult problem that is related to matching some customer names.
I have 2 Col, Col B(Name1) is raw data Col;Col F(Non-Sorted Name) is another name Col with difficult naming pattern which is not exactly matches.
Given: Col B (Raw data Col) , Col F (i.e. non-sorted names Col)
Task: Return the names of Col C (Name2) , i.e. Given Blue, I want to return Red!!!!!
You can see the image and the image can explain all the problems!!!
Actually it is just like a kind of "GOOGLE SEARCH" and searching names that matches with the most of the characters in the greatest amount of extent.
Actually, I think this nightmare problems just like "GOOGLE SEARCH"
That means finding a string and then highlighting the true hit parts / return the greatest extent of matches answers if possible.
ANOTHER LINK:
TABLE:
Row\Col | A | B | C | D | E | F |
1 | No. | Name1 | Name2 | Problems | Non-Sorted Name | |
2 | 1 | SEE CHAN MA APPLE JOHN / SEE CHAN YO KEEL BABY(JOINT NAME) | John, See chan ma apple Baby, See chan yo keel | Line Break, Comma | John, See chan ma apple Baby, See chan yo keel | |
3 | 2 | XA,YOO / LEE_JBO(JOINT NAME) | Xa Yoo Jbo, Lee | Line Break, Comma | Alevel Super Sgo M. J. | |
4 | 3 | HE, XIA CHAN DAN, DONGWANG | Dong, wang Dan Xiachan He | Name Reverse | Catup Mum Leo A. | |
5 | 5 | ALEVEL, SUPER SGO MOTHER JESSY | Alevel Super Sgo M. J. | Abbreviation | chin hu, offline cgo kathy, online | |
6 | 6 | Catup, Mum Leo April | Catup Mum Leo A. | Abbreviation | CO JUSUPER | |
7 | 7 | COO, THAN | THAN COO | Name Reverse, Comma | CO JU-YEAH | |
8 | 8 | ONLINE CGO KATHY / OFFLINE CHIN HU (JOINT NAME) | chin hu, offline cgo kathy, online | Name Reverse, Joint Name, Line Break | Dong, wang Dan Xiachan He | |
9 | 9 | TAMKOO LO | Tam Koo, Lo | Name padded | JU YUPER, QO | |
10 | 10 | LI, MARYME | Marymeli | Name Reverse+Name padded, comma | JU-YEAH-AO | |
11 | 11 | Zoo, catup_SHAN | Zoo shan catup | underscore, comma | Mary, Co Yu Yeah | |
12 | 12 | CO-JU YEAH | CO JU-YEAH | Duplicated first name | Marymeli | |
13 | 13 | CO JU Mary YEAH | Mary, Co Yu Yeah | Duplicated first name with one name | Playu, So_Ju | |
14 | 14 | CO JU SUPER | CO JUSUPER | Duplicated first name with name padded | Roger, CO_JU-SUPER | |
15 | 15 | CO JU SUPER, ROGER | Roger, CO_JU-SUPER | Duplicated first name with name padded+Name Reverse | SO JU YEAH | |
16 | 16 | SO JU YEAH | SO JU YEAH | Duplicated Last 2 name(from No.12) | SO JU_YUPER | |
17 | 17 | SO JU YUPER | SO JU_YUPER | Duplicated first name with last name different | Tam Koo, Lo | |
18 | 18 | SO JU PLAY U | Playu, So_Ju | Duplicated first name with last name different+Name Reverse+padded | THAN COO | |
19 | 19 | QO YUPER JU | JU YUPER, QO | Duplicated Last name with surname name different | Xa Yoo Jbo, Lee | |
20 | 20 | AO JU YEAH! | JU-YEAH-AO | Duplicated Last name with last name different+Name Reverse+padded | Zoo shan catup | |
21 | ||||||
22 | Given Blue, I want to return Red!!!!! |
<tbody>
</tbody>