View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Approximate match on string of text

Hi,

What do you mean by 'Find', what are you trying to do?

Mike


"Pierre" wrote:

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?