LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 142
Default MS Excel 2000 - Compare two lists of data.

I have two different files, both use the same unique identifiers. How can I
ascertain which records are missing from the smaller file.

For example:

File A, has 28,225 different records.
File B, has 14,205 different records.

Which records from File A, are missing from File B?

Thank you, Jerry
 
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 to compare multiple lists of data in excel DREAM MERCHANT Excel Discussion (Misc queries) 1 May 1st 06 01:09 PM
Compare two lists of data to find new entries Bugaglugs Excel Discussion (Misc queries) 1 November 21st 05 06:53 PM
compare data in two lists to find matching entries Chris(new user) Excel Discussion (Misc queries) 1 March 19th 05 10:36 PM
compare data in two lists to find matching entries Chris(new user) Excel Discussion (Misc queries) 1 March 19th 05 09:49 PM
compare data in two lists to find matching entries Chris(new user) Excel Discussion (Misc queries) 0 March 19th 05 08:49 PM


All times are GMT +1. The time now is 06:00 AM.

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"