comparing text strings (problem formula-any ideas, Mark W or Aladin)
Posted by carl on June 20, 2001 5:59 PM
Thank you for your help earlier in the year with the formula below. The formula works well however it has problems with words that have a double letter in common. For 'doll' and 'roll' it should return a value of 3 letters in common (position and identity independent), however the formula returns a value of 2. Sorry for not making the identity independence parameter clear in my initial request for help. Any ideas? There were a couple of other similar formulas suggested previously however all have the same problem. Thanks, Carl.