fuzzy logic matching in Excel

D

Davie

Is there such a thing as fuzzy logic matching in excel?

For example, if I have
Name Addr1 Addr2 Addr3
Davie Kings Road London England

and

Davie Kings Road - London

This should match as a potential pair. How can I do this in Excel?

Any ideas?
 
D

Dave Peterson

Nothing built in.


Is there such a thing as fuzzy logic matching in excel?

For example, if I have
Name Addr1 Addr2 Addr3
Davie Kings Road London England

and

Davie Kings Road - London

This should match as a potential pair. How can I do this in Excel?

Any ideas?
Click to expand...
 
Top