** Excel Formula

		Microsoft Office Forums > Microsoft Excel > Excel
** Excel Formula

FAQ

Thread Tools

Display Modes

04-15-2011, 03:55 PM

macropod

Windows 7 32bit ** Excel Formula

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to solve this formula in excel	BrOkEn_iCe	Excel	2	12-21-2010 05:45 AM
excel help Formula	sellspeed	Excel	15	03-10-2010 10:57 AM
Needs help to find excel formula- Please	aamer_1983	Excel	2	07-13-2009 01:46 AM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 AM.