| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Approximate match on string of text
I am looking for a solution to the following problem: I have a long list of
companies in an EXCEL sheet, and would like to find, company by company, if there is an approximate match with a name in another long list. Concretely, I would like to be able to match €śBlue Circle Productions€ť with €śBlue Circle Production€ť. Any idea? How would I set the degree of tolerance? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I match using partial or approximate values? | Excel Worksheet Functions | |||
| Vlookup Approximate Match Question | Excel Worksheet Functions | |||
| Excel: HLOOKUP Text "approximate" match over 2 sheets problem? | Excel Discussion (Misc queries) | |||
| Vlookup approximate match question. | Excel Worksheet Functions | |||
| Text string comparison - closest match | Excel Discussion (Misc queries) | |||
Threaded Mode
