Comparing first and last names in two lists

[garyp]

I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.

 

[Dave Peterson]

I think I'd concatenate the first and last names with a formula like: =a1&"."&b1
and copy down both lists.

Then I'd look at some of the techniques at Chip Pearson's page for dealing with
duplicates.
http://www.cpearson.com/excel/duplicat.htm

Then use