Thread: [Solved] ** Excel Formula
View Single Post
 
Old 04-15-2011, 03:55 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Rey,

Comparing names that are alike, requires 'fuzzy matching', which is a task for vba.

You might care to look here for an idea of what's involved: http://www.mrexcel.com/forum/showthread.php?p=331454

Sometimes its easier to simply highlight the entries that aren't an exact match and eyeball them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote