Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

Sandy wrote:

I have 2 file which are similar, I want to find all the records from one that
exsist in the other.

EX John Doe is in both files, how can I tag them, or merge them or something.
Even just tagging them I could remove the ones that don't get tagged

--

Dave Peterson