Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Compare names on two worksheets

I have one Excel worksheet with one column of personal names on it. I have a
2nd Excel worksheet that has several columns of personal names on it. I need
to compare the 1st worksheet to the 2nd worksheet for any misspellings.
(Microsoft Excel Office Edition 2003 SP2)
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default Compare names on two worksheets

http://www.cpearson.com/excel/Duplicates.aspx

you are actually looking for non duplicates but the method works fine for
that too


--


Regards,


Peo Sjoblom


"egreen" wrote in message
...
I have one Excel worksheet with one column of personal names on it. I have
a
2nd Excel worksheet that has several columns of personal names on it. I
need
to compare the 1st worksheet to the 2nd worksheet for any misspellings.
(Microsoft Excel Office Edition 2003 SP2)



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
How do you compare names in two lists? One is a subset. MAG Excel Worksheet Functions 1 July 25th 06 09:44 PM
Compare and match names and extract a cell content dexsourcesys Excel Worksheet Functions 1 January 19th 06 07:51 PM
Compare worksheets praveen_khm Excel Worksheet Functions 0 January 17th 06 05:54 PM
Compare two lists of names ea Excel Discussion (Misc queries) 1 December 22nd 05 01:31 AM
How do I compare two lists of names in excel? Jack the Cate Excel Discussion (Misc queries) 1 December 24th 04 12:07 PM


All times are GMT +1. The time now is 04:51 PM.

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

About Us

"It's about Microsoft Excel"