Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default similar names - two spreadsheets

I have two spreadsheets. 1 has the names of new customers and 1 has names of
prospects. I want to figure out if a prospect became a customer, but the
names may be similar and not identical. Is there a way to compare
information from one spreadsheet to another and pinpoint items that are
similar?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 411
Default similar names - two spreadsheets

You could add a column on both sheets called "Matchkey". That
concatenates, for example, the first five characters of the last name,
the first character of the first, name, and the zip code, or phone
number.

Then compare the matchkey fields.
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default similar names - two spreadsheets

Thank you, for your response. I don't follow the "Matchkey" suggestion. How
would that work? The names are company names. One might have US Systems and
the other U. S. Systems. Is there a way to compare the names and match
similarities? I don't have address and zip codes on both spreadsheets, only
company names.

"dan dungan" wrote:

You could add a column on both sheets called "Matchkey". That
concatenates, for example, the first five characters of the last name,
the first character of the first, name, and the zip code, or phone
number.

Then compare the matchkey fields.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 411
Default similar names - two spreadsheets

Well, in that case, you could copy each list so you have a backup of
the data, select the column and delete spaces, commas and periods.
then compare the lists with the Match function.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding blank rows between groups of similar names Justin Excel Worksheet Functions 2 July 6th 07 07:28 PM
Excel on the web similar to google spreadsheets Alex Excel Discussion (Misc queries) 1 February 24th 07 04:33 PM
Finding the MAX number while considering similar names Ninjapowa Excel Discussion (Misc queries) 3 November 4th 06 06:06 AM
Can you compare similar spreadsheets to determine a difference? DLopez79 Excel Discussion (Misc queries) 1 January 9th 06 10:36 PM
SIMILAR NAMES IN A TABLE Dimitri Kryukov Excel Discussion (Misc queries) 5 June 28th 05 03:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"