Side by Side Worksheet Functions

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

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
Click to expand...
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 for the quick response. On your page it seems to indicate the data sets need to be on the same page, and I can do that in order to facilitate, but here is more information Sheet 1 are names registered in a global corporate LDAP directory (somewhat static.) Sheet 2 are names out of an authoritative HR database of active employees (some could be new or re-hires.

Sheet 1 Sheet
adams, bill adams, fre
adams, fred adams, ton
adams, tony blair, to
blair, tom bush, ji

After the sort, adams, fred adams, tony and blair, tom would match (appear in both databases). Adams, Bill would fall out of Sheet 1 and need to be checked to see if the employee name was still valid. Bush, Jim would fall out of list 2 as an employee (probably new) that needed to have his email registered in the dorectory database.
 
Back
Top