PC Review


Reply
Thread Tools Rate Thread

Comparing names in different columns

 
 
=?Utf-8?B?Sw==?=
Guest
Posts: n/a
 
      21st Mar 2007
Hi there,

Sometimes a name is written as John Smith, sometimes JohnSmith, sometimes
JSmith sometimes J. A. Smith,

Is there a routine that somehas made to help us compare to see if the names
match?

(Only if its full last name and full first name do we consider it a match.)

Thanks for your help in advance

K
 
Reply With Quote
 
 
 
 
okrob
Guest
Posts: n/a
 
      21st Mar 2007
On Mar 21, 12:08 pm, K <K...@discussions.microsoft.com> wrote:
> Hi there,
>
> Sometimes a name is written as John Smith, sometimes JohnSmith, sometimes
> JSmith sometimes J. A. Smith,
>
> Is there a routine that somehas made to help us compare to see if the names
> match?
>
> (Only if its full last name and full first name do we consider it a match.)
>
> Thanks for your help in advance
>
> K


Can you elaborate? Do you have a list of names somewhere that you are
comparing the list to?
What do you want to do with the ones that match? Or do you just want
a count of matches?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing two columns and finding matching names =?Utf-8?B?ZXhjZWxpc3N1ZQ==?= Microsoft Excel Worksheet Functions 1 12th Oct 2007 12:53 AM
how to insert workbook names and worksheet names to access columns =?Utf-8?B?Z29rb3A=?= Microsoft Access Queries 12 31st Aug 2007 03:52 PM
how to copy workbook names and worksheet names to columns in acces =?Utf-8?B?Z29rb3A=?= Microsoft Excel Programming 4 27th Aug 2007 11:26 AM
Comparing two names =?Utf-8?B?TWlrZQ==?= Microsoft Excel Worksheet Functions 3 11th Jul 2007 05:12 PM
Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns? William.R.Reisen Microsoft Access External Data 2 20th Dec 2003 02:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:13 AM.