#1   Report Post  
Posted to microsoft.public.excel.misc
coastwalker
 
Posts: n/a
Default Comparing databases


I have one 'master' database, and will be having to match it up with
several other databases that come in once a month for about 6 months.
All the databases will include person's names (as well as other
information), and I want to be able to segregate out everyone on the
additional databases whose name does not appear on the 'master'
database. Is there an easy way to do this?

Thanks!


--
coastwalker
------------------------------------------------------------------------
coastwalker's Profile: http://www.excelforum.com/member.php...o&userid=34490
View this thread: http://www.excelforum.com/showthread...hreadid=542558

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Comparing databases

By any chance is there a unique identifier in each record that would
differentiate between multiple instances of "John Smith"? This would
help immensely.

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
Comparing databases and returning values Jonas Excel Worksheet Functions 0 March 6th 06 04:41 PM
Comparing two worksheets with two columns each for duplicates jlcnewyork Excel Discussion (Misc queries) 0 February 15th 06 02:32 PM
Comparing two spreadsheets Morten Excel Worksheet Functions 1 October 21st 05 02:30 PM
Comparing two lists in excel that don't match exactly Tina Excel Worksheet Functions 2 May 11th 05 05:00 PM
Comparing Data in two columns Marianne Excel Worksheet Functions 3 November 5th 04 10:26 PM


All times are GMT +1. The time now is 10:10 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"