Record duplication

Tabitha Hammond · Nov 24, 2005

Hiya
I¹ve got two lists with 10k records in each and I want to see which records
appear in both lists.
Is there a way of doing this in excel?
Tab

Gord Dibben · Nov 24, 2005

Tabitha

See Chip Pearson's site for working with, tagging and extracting duplicates.

Extracting from two lists is down near the bottom of the page.

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Gord Dibben Excel MVP