| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching/comparing lists | Excel Worksheet Functions | |||
| Comparing two columns and finding matching names | Excel Worksheet Functions | |||
| My IF statement is stating False but if I manual calculate it it | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
| Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions | |||
Threaded Mode
