If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Comparing & Stating The Nearest Matching
Expertise requested for the following case:
Suppose I have a list and the item in Cell A2 is: "United Bank Limited" Other list states different options like: UBL United Bank United Bank Ltd. and Bank United Limited Any suggestions to check out and come up with the most similar ENTRY or most similar WORDS? The one to be reflected in B2 should be "United Bank Ltd." and NOT "Bank United Limited" as the characters are atleast in the same order. All sugestions are obliged! Thanx again! -- Best Regards, FARAZ A. QURESHI |
#2
|
|||
|
|||
Comparing & Stating The Nearest Matching
Mathematicans have been generating algorithms to to this for years. Numerous
thesis papers have been written on this topic. the solution is a very complex macro. The best solution is to list each option in a seperate column. then search for a match in eevery column. "FARAZ QURESHI" wrote: Expertise requested for the following case: Suppose I have a list and the item in Cell A2 is: "United Bank Limited" Other list states different options like: UBL United Bank United Bank Ltd. and Bank United Limited Any suggestions to check out and come up with the most similar ENTRY or most similar WORDS? The one to be reflected in B2 should be "United Bank Ltd." and NOT "Bank United Limited" as the characters are atleast in the same order. All sugestions are obliged! Thanx again! -- Best Regards, FARAZ A. QURESHI |
#3
|
|||
|
|||
Comparing & Stating The Nearest Matching
Thanx 4 replying Joel!
However, what is meant by listing options in different columns? and any idea or source of such a complex macro or topics on net! Thanx again. -- Best Regards, FARAZ A. QURESHI "Joel" wrote: Mathematicans have been generating algorithms to to this for years. Numerous thesis papers have been written on this topic. the solution is a very complex macro. The best solution is to list each option in a seperate column. then search for a match in eevery column. "FARAZ QURESHI" wrote: Expertise requested for the following case: Suppose I have a list and the item in Cell A2 is: "United Bank Limited" Other list states different options like: UBL United Bank United Bank Ltd. and Bank United Limited Any suggestions to check out and come up with the most similar ENTRY or most similar WORDS? The one to be reflected in B2 should be "United Bank Ltd." and NOT "Bank United Limited" as the characters are atleast in the same order. All sugestions are obliged! Thanx again! -- Best Regards, FARAZ A. QURESHI |
Thread Tools | |
Display Modes | |
|
|