Results 1 to 3 of 3

Thread: Closest Match

Threaded View

  1. Jun 1st, 2006, 01:26 PM #1
    arnie1066
    arnie1066 is offline

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    6

    Question Closest Match

    Excel VBA:
    Is there a way to check a string against a list of other strings and find it's closest match.

    E.G
    <List>
    Freddie
    Mr Fred
    Mr Freddy
    Fred Jnr
    Isabel
    Uncle Sam

    <Input String>
    Fredy


    In this case it would be closer to Mr Freddy, how can i do that in code.
    Even if i get a % match for each one i can then use the highest %.


    So is this unmanagable??
    Last edited by arnie1066; Jun 5th, 2006 at 06:50 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width