Side by Side Worksheet Functions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/04/04 

Date: Tue, 4 May 2004 07:45:05 -0700

Hi
you may post some example data (if both data structures
are not identical).
As a generic solution see:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
>-----Original Message-----
>I have 2 long user info extracts which I need to compare
side-by-side and pull out the user names that do not
match. One has current SMTP addresses registered in a
directory database, the other is current employees out of
an HR database. If I can compare names (last name, first
name) those that match (TRUE?) are registered in both
databases, those that fall out need to either be pruned
(employee no longer there) or registered (new employee not
in directory.) Any ideas as to correct function to
compare criteria and facilitate this type of sort? Any
help or ideas would be greatly appreciated.
>
>Thanks in advance.
>.
>

Quantcast