Comparing two spreadsheets

[Alex F. Buiel II]

Is there any way to compare one large spreadsheet against another to
ascertain what names are missing off of the second file that are on the
first one? I hope I explained that clearly because my brain has turned to
mush at this point.

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/duplicat.htm#InOneNotOther