How do I compare 1 excel file to another and save what is a match

[DSerum]

If I have Excel file-1 with 100 records and Excel file-2 with 1000 records.
How can I compare records between the two and only save records or flag
records that have a match ???

 

[Bernard Liengme]

Start by looking a Chip's index: http://www.cpearson.com/excel/topic.htm
He has a number of "Duplicate" entries; I expect one will answer your
question.
If not please come back
best wishes