I want to find duplicate entries in two different excel workbooks. I am
trying to eliminate the manual process of finding people who are not on the
2nd list, but are on the first one.

one of the ways to do it
if your data is in column A in both workbooks
in B1 enter
=Countif([select the column in workbook2],A1)
copy this equation down to the bottom of your data.
Do autofilter on column B and select 0
this will be the names in Workbook 1 which are not in Workbook 2

one word of caution. the names must be exactly identical for this to work.

"mlarson47" wrote:

I want to find duplicate entries in two different excel workbooks. I am
trying to eliminate the manual process of finding people who are not on the
2nd list, but are on the first one.