View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dennis Tucker Dennis Tucker is offline
external usenet poster
 
Posts: 140
Default Approximate match on string of text

I would assume that when you match €śBlue Circle Productions€ť with €śBlue
Circle Production€ť, you would delete one or the other entry. Is that right?

Are you merging the two lists?

Dennis

"Pierre" wrote in message
...
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?