Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm


mike wrote:

i have two tabs in an excel spreadsheet. The first tab is an older list of
names with the last name in column A and the first name in column b. The
second tab is a recent list with last names in column A and the first name in
column B. How do i search the lists to find names added in the recent list
that are not on the original list? I need to find out what names were added
since the first list was created.

--

Dave Peterson